If we are used to the Query Analyser of SQL Server 2000, we might find it frustrating that the query window does not automatically come up when you start SSMS.
You have to either press Ctrl+N or Click on New Query to start it up.
Here is a way to start up the New Query window automatically.
Click on Tools-- Options click on the + to exapnd environment and click on General.
The following screen comes up.
Click on the drop down beside start up and choose ' Open Object Exlpoer and New query'.
Click Ok. Next time when you open SSMS the query window will automatically be opened for you.
Here is link to the blog I posted in my BIDN blog.
I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...