MS SQL Server Tools - SQL 2005 Scripts Problem

Author

SQL 2005 Scripts Problem

Anatoly Kurilin

2006-11-27, 7:17 pm

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

Erland Sommarskog

2006-11-27, 7:17 pm

Anatoly Kurilin (akurilin@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Paul A. Mestemaker II [MSFT]

2006-11-28, 12:15 am

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/

"Anatoly Kurilin" <akurilin@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
>
>

Sponsored Links