Top "Ssms" questions

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

How can I execute a set of .SQL files from within SSMS?

How could I execute a set of .SQL files (each does some data transformations) from within SQL Server Management Studio? …

sql-server batch-file ssms
Right click script alter table disabled in SQL Server Management Studio

I want to script a table as Alter to a New Query Editor Window. But this option is disabled. How …

sql-server ssms alter-table
sql server 2012: cannot alter the login sa

I'm trying to create a database on my local machine using SSMS version 11.0.2100.60. I've run the application as administrator, logged …

ssms sql-server-2012-express
IntelliSense is not working in SQL Server Management Studio

We use SQL Server Management Studio 2008 R2. IntelliSense works with SA account perfectly. But it is not working with Windows …

sql-server sql-server-2008-r2 ssms
SQL Management Studio won't recognize a table exists after scripted create

So if I create a new table in the query editor in SQL Management Studio after hitting refresh on the …

sql sql-server ssms
Add unique constraint in SQL Server 2008 GUI?

I have an existing table with data. I have just added a new column but I cannot find how to …

sql sql-server ssms sql-server-2008
Convert GUID to varchar(32)

How can I convert a GUID which is 36 characters to a VARCHAR(32)? I'm trying to copy data from one table …

sql sql-server ssms guid varchar
rename database name in sql server management studio 2014

I have a database called "ip_ent_site". And I wanna rename it to "ip_ent_site1" for example. I …

sql sql-server tsql ssms
Import database (SQL file) in SQL Server Management Studio

I've created the structure of my database first in PhpMyAdmin and exported it to a .sql file. Now I'm looking …

file import ssms sql-server-2014
How to set (combine) two primary keys in a table

For a small sales related application, we designed database using logical data model. Come to the stage to convert in …

ssms sql-server-express database composite-primary-key