Wednesday, March 7, 2012

MS SQL 2005 generate separate table scripts

How do you generate separate scripts for all the objects such as
Tables or Store Procedures? This was an option in SQL 2000Are you referring to Right-click the database, Tasks, "Generate Scripts"?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CompSci" <ruchir.jaipuriyar@.gmail.com> wrote in message
news:1170260018.511018.128670@.j27g2000cwj.googlegroups.com...
> How do you generate separate scripts for all the objects such as
> Tables or Store Procedures? This was an option in SQL 2000
>|||This is supported in SP2
(http://download.microsoft.com/downl...anagementStudio).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||On Jan 31, 10:44 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> This is supported in SP2
> (http://download.microsoft.com/downl...7-423d-bc8f-...)
.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
there is no other way to do this untill sp2 comes out?|||Some options at: http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CompSci" <ruchir.jaipuriyar@.gmail.com> wrote in message
news:1170334953.424668.248760@.a75g2000cwd.googlegroups.com...
> On Jan 31, 10:44 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> there is no other way to do this untill sp2 comes out?
>

No comments:

Post a Comment