Introduction: In this article i am going to explain the short cut way to start sql server from command prompt.
Description: Everybody know how to start Sql server by just clicking on the shortcut icon but very few of them know that sql server can also be launched from command line prompt. It’s very simple and also fast. Also sometimes asked in interview questions. Here is the way:
Similar useful articles
Description: Everybody know how to start Sql server by just clicking on the shortcut icon but very few of them know that sql server can also be launched from command line prompt. It’s very simple and also fast. Also sometimes asked in interview questions. Here is the way:
Sql server 2005
- To start SQL Server Management Studio 2005 from Command Prompt follow as:
Click Start -> Run -> Type sqlwb.exe and press enter
or Start -> Run -> cmd -> Type sqlwb.exe and press enter
or Start -> Run -> cmd -> Type sqlwb.exe and press enter
- You can pass different parameters with the command also . To see the list of parameters suffix the command as:
Click Start -> Run -> Type sqlwb.exe /? Or sqlwb.exe -?
or Start -> Run -> cmd -> Type sqlwb.exe /? Or sqlwb.exe -?
or Start -> Run -> cmd -> Type sqlwb.exe /? Or sqlwb.exe -?
Usage:
sqlwb.exe [-S server_name[\instance_name]] [-d database] [-U user] [-P password] [-E] [file_name[, file_name]] [/?]
sqlwb.exe [-S server_name[\instance_name]] [-d database] [-U user] [-P password] [-E] [file_name[, file_name]] [/?]
[-S The name of the SQL Server instance to which to connect]
[-d The name of the SQL Server database to which to connect]
[-E] Use Windows Authentication to login to SQL Server
[-U The name of the SQL Server login with which to connect]
[-P The password associated with the login]
[file_name[, file_name]] names of files to load
[-nosplash] Supress splash screen
[/?] Displays this usage information
[-d The name of the SQL Server database to which to connect]
[-E] Use Windows Authentication to login to SQL Server
[-U The name of the SQL Server login with which to connect]
[-P The password associated with the login]
[file_name[, file_name]] names of files to load
[-nosplash] Supress splash screen
[/?] Displays this usage information
SQL Server 2008/2012
To start SQL Server Management Studio 2008 or SQL Server Management Studio 2012 from Command Prompt:
To start SQL Server Management Studio 2008 or SQL Server Management Studio 2012 from Command Prompt:
Click Start -> Run -> Type SSMS.exe and press
enter
or Start -> Run -> cmd -> Type SSMS.exe and press enter
or Start -> Run -> cmd -> Type SSMS.exe and press enter
You can also pass different parameters with the command. To
see the list of parameters suffix the command as:
Click Start -> Run -> Type ssms.exe /? Or ssms.exe
-?
or Start -> Run -> cmd -> Type SSMS.exe /? Or ssms.exe -?
or Start -> Run -> cmd -> Type SSMS.exe /? Or ssms.exe -?
Usage:
ssms.exe [-S server_name[\instance_name]] [-d database] [-U user] [-P password] [-E] [file_name[, file_name]] [/?]
ssms.exe [-S server_name[\instance_name]] [-d database] [-U user] [-P password] [-E] [file_name[, file_name]] [/?]
[-S The name of the SQL Server instance to which to connect]
[-d The name of the SQL Server database to which to connect]
[-E] Use Windows Authentication to login to SQL Server
[-U The name of the SQL Server login with which to connect]
[-P The password associated with the login]
[file_name[, file_name]] names of files to load
[-nosplash] Supress splash screen
[/?] Displays this usage information
[-d The name of the SQL Server database to which to connect]
[-E] Use Windows Authentication to login to SQL Server
[-U The name of the SQL Server login with which to connect]
[-P The password associated with the login]
[file_name[, file_name]] names of files to load
[-nosplash] Supress splash screen
[/?] Displays this usage information
Ø How to delete all tables from Sql server Database
Ø How to delete all stored procedures from sql server database
Ø How to delete all views from sql server database
Ø How to delete all triggers from sql server database
Ø Take automatic backup of Sql server Database
Ø Copy all data from one table to another in the same database in Sql Server
Ø Copy all data from one database table to another database table in Sql Server
Ø Date format in sql server
Ø How to concatenate two strings in Sql Server
Ø How to remove column from table in SQL server
Ø How to take Sql server database backup
Ø How to select records between specified range in SQL Server ?
Ø How to retrieve specific range of rows from SQL Server database table ?
Ø How to delete all stored procedures from sql server database
Ø How to delete all views from sql server database
Ø How to delete all triggers from sql server database
Ø Take automatic backup of Sql server Database
Ø Copy all data from one table to another in the same database in Sql Server
Ø Copy all data from one database table to another database table in Sql Server
Ø Date format in sql server
Ø How to concatenate two strings in Sql Server
Ø How to remove column from table in SQL server
Ø How to take Sql server database backup
Ø How to select records between specified range in SQL Server ?
Ø How to retrieve specific range of rows from SQL Server database table ?
If you have any question about any post, Feel free to ask.You can simply drop a comment below post or contact via Contact Us form. Your feedback and suggestions will be highly appreciated. Also try to leave comments from your account not from the anonymous account so that i can respond to you easily..