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.
Today I thoroughly enjoyed presenting on the topic "Google Forms Meets Power BI via SSRS " The aim of this session was to provid...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...