Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Using Management Studio unable to select "create one file per object"?

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 accomplish the same:

Right-click on a database, select Tasks, then select Generate Scripts. A wizard begins. After several screens, there is the option to select "File per object", which will do what you want to do. 

If you are unable to see that option within your SSMS screen then ensure to upgrade the SQL Server 2005 client tools to Service Pack 2. It is a normal practice that most of the DBAs missing applying SP to client tools installation too.

 

Posted: Wednesday, October 17, 2007 2:06 AM by SQL Master

Comments

SSQA.net - SqlServer-QA.net said:

One of the Developer complained that he is unable to create one file per object using Generating SQL

# October 17, 2007 3:01 AM

Other SQL Server Blogs around the Web said:

One of the Developer complained that he is unable to create one file per object using Generating SQL

# October 17, 2007 5:24 AM
Anonymous comments are disabled