Top "Ssms" questions

Microsoft SQL Server Management Studio is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

Import / Export database with SQL Server Server Management Studio

I thought this would be trivial, but it isn't... I'm sure there is a simple way to do it but …

sql-server import export ssms
SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant …

sql sql-server sql-server-2008 ssms
How do you specify a different port number in SQL Management Studio?

I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a …

sql-server sql-server-2005 ssms
Format SQL in SQL Server Management Studio

In Visual Studio & other IDEs, you can easily auto format your code with a keyboard shortcut, through the menu, …

sql-server formatting ssms
How to drop all tables in a SQL Server database?

I'm trying to write a script that will completely empty a SQL Server database. This is what I have so …

sql-server sql-server-2008 ssms sp-msforeachtable
How to quickly edit values in table in SQL Server Management Studio?

Aside from context menu -> "Edit Top 200 Rows" from Object Explorer, is there a quick way to open a …

sql sql-server ssms
What is the use of GO in SQL Server Management Studio & Transact SQL?

SQL Server Management Studio always inserts a GO command when I create a query using the right click "Script As" …

sql-server tsql ssms
The request failed or the service did not respond in a timely fashion?

I have the following error while I connect to SQL Server 2008 Management Studio with Windows authentication. "The request failed or …

sql-server sql-server-2008 ssms
Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

sql sql-server tsql sql-server-2012 ssms
How do I grant myself admin access to a local SQL Server instance?

I installed SQL Server 2008 R2 to my local machine. But, I can't create a new database because of rights (or …

sql sql-server sql-server-2008 ssms sqlcmd