Sunday, January 19, 2014

CONNECT SQL SERVER USING COMMAND PROMPT


Connecting to Command  Prompt
    Type Windows + R  (Run)
    Type CMD and Press Enter Key 
 
Connecting to the Management Studio
      Type SSMS and Press Enter Key
Connecting to a SQL Server Management studio using integrated authentication
        Type SSMS –E and press Enter Key
Connecting to a specific database in SQL Server Management studio using integrated authentication
        Type SSMS –E –D <<Database Name>> and press Enter Key
        E.g., SSMS –E –D Test
To find out the various options that are available
        Type SSMS /?

No comments:

Post a Comment