Connecting to SQL Server using Command Prompt

 I was going through the videos in VirtualTech days, I found that there are some interesting tips given by the speaker Vinod Kumar. I thought  of sharing some of the tips in coming days so that it might be helpful for others as well.
 
Following are some of the options that are available to connect to SQL Server management studio 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

onnecting 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 /?

Please leave your valuable comments on this article…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s