Top "Ssms" questions

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

Cannot connect to (LocalDB)\MSSQLLocalDB -> Login failed for user 'User-PC\User'

I am getting an error, While I am trying to connect (LocalDB)\MSSQLLocalDB through SQL Server management studio. I also …

sql sql-server ssms localdb
How can I resolve the "Table 'dbo.Foo' already exists." error when the table does not exist?

I've created a table and then realised I made a mistake. SSMS wouldn't let me update the table without recreating …

sql-server ssms
Error when installing SSDT (SQL Server Data Tools)

I have a problem during the installation of SQL Server Data Tools for Visual Studio 2017 I get the following error (…

sql visual-studio-2017 ssms sql-server-data-tools sql-server-2017
SQL Management Studio Plug-ins for Intellisense/Autoformat?

Are there any free, or cheap plug-ins/add-ons for SQL Management Studio that provide intellisense and (less importantly) some auto-formatting? …

sql plugins intellisense ssms add-on
How can I manage SQL CE databases in SQL Server Management Studio?

I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database). Is it possible to edit …

sql-server-ce ssms
SQL Server Management Studio won't let me add an index to a table

When I right click on the indexes folder in the table the "New Index" menu item is grayed out. I …

sql-server sql-server-2008 sql-server-2012 ssms sql-server-2014
SQL Server Management Studio SSMS tries to "save to file" instead of execute on F5

This happens intermittently and seems to be related to accidentally hitting a key. Any ideas what causes this?

sql-server-2008 ssms
How to extract MSSQLServer database as .dacpac without VerifyExtraction?

I want to extract a database schema of a MSSQLServer database with Server Management Studio. I use the Extract command "…

sql-server database ssms data-tier-applications
How to remove cached server names from the Connect to Server dialog?

Or, to put it another way, where is SqlStudio.bin for SQL Server 2012? It doesn't seem to be in the …

sql-server caching login sql-server-2012 ssms
How to get the relative path of file in SQLCMD Mode in SSMS?

I have the below master script which creates tables, and inserts some data and then creates the stored procedures. --todo_…

sql-server ssms sqlcmd