IT Nursery
I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server name....
When trying to connect to a server in Management Studio (specifically 2008), there is a field where you enter the Server name. That field also has a drop-down list...
Can we see the values (rows and cells) in a table valued variable in SQL Server Management Studio (SSMS) during debug time? If yes, how? 9 Answers 9
I am using SQL Server Management Studio. I wish to save the results of a query to an excel file. I choose “save as” and then save to CSV...
Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can you give me any advice on...
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 create a new Login by right-clicking...
In SQL Server 2008 Management Studio, when I right click on a database table and choose “Select Top 100 Rows“, I can then e.g. easily add a “ORDER BY...
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 rows. I have another database (call...
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 to find it. Shame on me....
I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop. I’ve installed SQL Server 2012 and have finally got SQL Server Data Tools to...