Top "Ssms" questions

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

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 …

sql-server ssms sql-server-2008
How do I view executed queries within SQL Server Management Studio?

I am new to SQL Server Management Studio and am wondering: is there is a way to see which queries …

ssms sql-server-express
How to edit data in result grid in SQL Server Management Studio

I want to edit some row values once I get a query output in the result grid. Its true that …

ssms
SQL Server 2008 can't login with newly created user

I'm using using Windows Vista and I'm having trouble logging in with a newly created user. I open SQL Server …

sql-server authentication login ssms
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 …

sql-server security login ssms
How to remove "Server name" items from history of SQL Server Management Studio

When trying to connect to a server in Management Studio (specifically 2008), there is a field where you enter the Server …

ssms
mssql '5 (Access is denied.)' error during restoring database

I want to restore a database from a file (Tasks → Restore → Database; after I select from device and select file) …

sql-server ssms
How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?

In this live SQL Server 2008 (build 10.0.1600) database, there's an Events table, which contains a text column named Details. (Yes, I …

sql-server sql-server-2008 ssms
SQL Server: Importing database from .mdf?

I have an .mdf file on my local box. I have SQL Server 2008 Express and SQL Management Studio 2008 Express installed …

sql-server database import mdf ssms
Restrict varchar() column to specific values?

Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008? For example, …

sql sql-server-2008 ssms