Browse by Tags

Using Management Studio unable to select "create one file per object"?

Published 17 October 7 4:6 AM | SSQA.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...

Filed under: sql server, ssms, script, 2000, service pack2, 2005, management studio, enterprise manager, generate

SQL Server 2005 how to copy database maintenance plans between the servers?

Published 15 October 7 8:54 AM | SSQA.net

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

Filed under: sql server, backup, ssis, ssms, maintenance plan, service pack2, management studio