Top "Ssms" questions

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

Saving results with headers in Sql Server Management Studio

I am using SQL Server Management Studio. I wish to save the results of a query to an excel file. …

sql sql-server-2008 excel ssms export-to-excel
The backend version is not supported to design database diagrams or tables

I'm trying to add a table to my newly created database through SQL Server Management Studio. However I get the …

sql sql-server database ssms
ALTER DATABASE failed because a lock could not be placed on database

I need to restart a database because some processes are not working. My plan is to take it offline and …

sql sql-server-2008 ssms
Converting Select results into Insert script - SQL Server

I have SQL Server 2008, SQL Server Management Studio. I need to select data from Table1 in database1. Then I have …

sql sql-server sql-server-2008 ssms
What is the T-SQL syntax to connect to another SQL Server?

If I need to copy a stored procedure (SP) from one SQL Server to another I right click on the …

sql-server tsql stored-procedures ssms
Find stored procedure by name

Is there any way I can find in SQL Server Management Studio stored procedure by name or by part of …

sql database sql-server-2005 ssms
Auto-increment primary key in SQL tables

Using Sql Express Management Studio 2008 GUI (not with coding), how can I make a primary key auto-incremented? Let me explain: …

sql-server-2008 ssms
How do I make a composite key with SQL Server Management Studio?

How do I make a composite key with SQL Server Management Studio? I want two INT columns to form the …

sql sql-server tsql ssms key
How do you view ALL text from an ntext or nvarchar(max) in SSMS?

How do you view ALL text from an NTEXT or NVARCHAR(max) in SQL Server Management Studio? By default, it …

sql-server sql-server-2008 tsql ssms
How do I create a SQL table under a different schema?

This is from SQL Server 2008, ssms When I create a table, it creates under dbo. I would like to create …

sql sql-server-2008 ssms