Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SSMS SQL2K5 Generate script

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2009-02-25 : 11:27:29
In SQL2K SSMS while generating object scripts, somewhere in the end there was an option for creating individual script file for each object.

I am not able to see this option in SQL2K5. Has this been removed?

------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-25 : 12:02:28
http://weblogs.sqlteam.com/peterl/archive/2008/10/24/How-to-script-out-all-your-objects-one-per-file.aspx
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2009-02-25 : 12:09:42
Thanks Sodeep.
Looks like this problem has been fixed in SP2.
http://earljon.wordpress.com/2008/04/10/sql-server-2005-scripting-each-objects-to-a-separate-file/



------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -