ssms Archives - IT Nursery

Programming, visual-studio-2010

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 ...

June 3, 2022
0 Comments

Programming, ssms

IT Nursery

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 name. That ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

How to see the values of a table variable at debug time in T-SQL?

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

June 1, 2022
0 Comments

Programming, sql

IT Nursery

Saving results with headers in SQL Server Management Studio

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

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

How to see query history in SQL Server Management Studio

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

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

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 Management Studio. I ...

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

How to alter SQL in “Edit Top 200 Rows” in SSMS 2008

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

May 28, 2022
0 Comments

Programming, sql

IT Nursery

How to export all data from table to an insertable sql format?

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 ...

May 27, 2022
0 Comments

Programming, sql-server

IT Nursery

Import / Export database with SQL Server Server Management Studio

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 ...

May 27, 2022
0 Comments

Programming, ssms

IT Nursery

Where is SQL Server Management Studio 2012?

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

May 26, 2022
0 Comments