SQL 2005 Scripts Problem

27 Nov 2006 9:01 PM

Anatoly Kurilin

Hi, used to have no problems with generating database scrips in version
2000, but now in version 2005, these scripts actually do not work! I mean I
run them to modify objects on the another SQL 2005 database but nothing
happans!??? And their text looks very stange. What do i do wrong?

Thanks in advance,
AK

27 Nov 2006 10:47 PM

Erland Sommarskog

Anatoly Kurilin (akuri***@nordsoft.ru) writes:

> Hi, used to have no problems with generating database scrips in version
> 2000, but now in version 2005, these scripts actually do not work! I
> mean I run them to modify objects on the another SQL 2005 database but
> nothing happans!??? And their text looks very stange. What do i do
> wrong?

Could you give a more concreate example of what you mean?

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

28 Nov 2006 4:33 AM

Paul A. Mestemaker II [MSFT]

There were some known issues with scripting in SQL Server 2005 RTM and SP1.
SP2 has fixed many of these. I suggest that you try it out and let us know
if anything is still broken.

SQL Server 2005 Service Pack 2 - November CTP:
http://www.microsoft.com/sql/ctp.mspx

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Show quote

"Anatoly Kurilin" <akuri***@nordsoft.ru> wrote in message
news:easw1cmEHHA.4312@TK2MSFTNGP06.phx.gbl...
> Hi, used to have no problems with generating database scrips in version
> 2000, but now in version 2005, these scripts actually do not work! I mean
> I run them to modify objects on the another SQL 2005 database but nothing
> happans!??? And their text looks very stange. What do i do wrong?
>
> Thanks in advance,
> AK
>
>