SqlServer-QA.net

Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message ''Microsoft SQL Server Management Studio is waiting for an internal operation to complete. If you regularly encounter this delay ...

One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects per file, and it is still available within SQL Server 2005 using Management Studio. To ...

How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version.  Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed the issues with Service Pack2 for SQL 2005. In general you can take help of ...