Stack Overflow
Stack Overflow

Questions tagged [ssms]

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

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for accessing, configuring, managing, administering and developing all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SSMS works with all components of SQL Server such as Reporting Services and Integration Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

On Wikipedia: SQL Server Management Studio

7484 questions
929
votes
15 answers

Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation

When I create a table in SQL Server and save it, if I try to edit the table design, like change a column type from int to real, I get this error: Saving changes is not permitted. The change you have made requires the following table to be dropped…
Arash
  • 9,705
  • 4
  • 18
  • 12
749
votes
24 answers

What is the best way to auto-generate INSERT statements for a SQL Server table?

We are writing a new application, and while testing, we will need a bunch of dummy data. I've added that data by using MS Access to dump excel files into the relevant tables. Every so often, we want to "refresh" the relevant tables, which means…
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
474
votes
12 answers

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" menu. Why? What does GO actually do?
tvanfosson
  • 524,688
  • 99
  • 697
  • 795
473
votes
6 answers

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 different port number when connecting to the server using SQL Management Studio?
Brettski
  • 19,351
  • 15
  • 74
  • 97
422
votes
19 answers

sql server invalid object name - but tables are listed in SSMS tables list

I am attempting to create a Stored Procedure for a newly created database. However the SSMS intellisense does not recognize more than half of the tables which have been created. For example whilst in the left hand column under tables I have a table…
Richbits
  • 7,344
  • 8
  • 33
  • 38
344
votes
4 answers

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, or automatically as you type. I was wondering if there is yet a way to enable this standard feature in SQL Server Management Studio? I'm…
lomaxx
  • 113,627
  • 57
  • 144
  • 179
308
votes
7 answers

Saving changes after table edit in SQL Server Management Studio

If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in table present) I get an error message: Saving changes is not permitted. The changes you have made require the following tables to be dropped…
rem
  • 16,745
  • 37
  • 112
  • 180
305
votes
7 answers

How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?
Zack Peterson
  • 56,055
  • 78
  • 209
  • 280
290
votes
4 answers

Unique constraint on multiple columns

CREATE TABLE [dbo].[user]( [userID] [int] IDENTITY(1,1) NOT NULL, [fcode] [int] NULL, [scode] [int] NULL, [dcode] [int] NULL, [name] [nvarchar](50) NULL, [address] [nvarchar](50) NULL, CONSTRAINT…
loviji
  • 12,620
  • 17
  • 63
  • 94
287
votes
11 answers

Removing the remembered login and password list in SQL Server Management Studio

I've recently used our company's spare laptop (that has a general user set up) while mine was being repaired. I've checked the "Remember password" option in SQL Server Management Studio when logging in to the database. I need to clear the login and…
Elanie Meyer
274
votes
2 answers

SQL Server. How to refresh the intellisense?

Possible Duplicate: Lost the IntelliSense SQL Server 2008 Intellisense problem In SQL Server 2008 R2, I've just imported a new data table and/or renamed fields in an existing table (it happens either way). When I start to write some SQL, the…
PowerUser
  • 11,583
  • 20
  • 64
  • 98
273
votes
17 answers

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 far: USE [dbname] GO EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all' EXEC sp_msforeachtable 'DELETE ?' When I run it in the…
dixuji
  • 2,733
  • 3
  • 14
  • 4
271
votes
8 answers

SQL Server Management Studio, how to get execution time down to milliseconds

When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. Is it possible to configure SSMS to show the query time with millisecond resolution? Here is the bar I am talking about with the section of…
Michael Goldshteyn
  • 71,784
  • 24
  • 131
  • 181
253
votes
11 answers

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 only seems to return the first few hundred characters (255?) but sometimes I just want a quick way of viewing the whole field, without having to…
NickG
  • 9,315
  • 16
  • 75
  • 115
246
votes
4 answers

How can I generate an INSERT script for an existing SQL Server table that includes all stored rows?

I'm looking for a way to generate a "Create and insert all rows" script with SQL Management Studio 2008 R2. I know that I can create a "create table" script. I can also create an "insert in" script, but that will only generate a single row with…
citronas
  • 19,035
  • 27
  • 96
  • 164
1
2 3
…
99 100