ssms Archives - IT Nursery

How to find server name of SQL Server Management Studio

I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with … Read more

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

Can we see the values (rows and cells) in a table valued variable in SQL Server Management Studio (SSMS) during debug time? If … Read more

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

Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can … Read more

I’m using using Windows Vista and I’m having trouble logging in with a newly created user. I open SQL Server Management Studio. I … Read more

In SQL Server 2008 Management Studio, when I right click on a database table and choose “Select Top 100 Rows“, I can then … Read more

I have a Table (call it A_table) in a database (call it A_db) in Microsoft SQL Server Management Studio, and there are 10 … Read more

I thought this would be trivial, but it isn’t… I’m sure there is a simple way to do it but I can’t manage … Read more

I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop. I’ve installed SQL Server 2012 and have finally … Read more