Tuesday, September 3, 2013

sqlcmd Utility

Manage SQL Server 2008 Express databases by using the sqlcmd utility from the command prompt.

To Login
Sql Server Authentication
sqlcmd -S server1\SQLExpress -U SqlUserAccount -P SqlPassword

Windows Authentication
sqlcmd -S server1\SQLExpress  -E

FOR DETAILS
http://technet.microsoft.com/en-us/library/ms165702%28v=sql.105%29.aspx

No comments:

Post a Comment