SqlServer-QA.net

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