Tuesday, June 07, 2011

SQL Server::SQLCMD

cd C:\Archivos de programa\Microsoft SQL Server\100\Tools\Binn
C:..>SQLCMD -s 192.168.1.30 -U sa -P pass


sp_databases
use

sp_help tablename
select * from SYSOBJECTS where TYPE = 'U' order by NAME


references:
[1] http://msdn.microsoft.com/en-us/library/ms180944.aspx
[2] http://msdn.microsoft.com/en-us/library/ms165702.aspx

No comments:

Firefox open multiple private window

    /opt/firefox/firefox-bin --profile $(mktemp -d) --private-window www.google.com www.bing.com