Posted by Erland Sommarskog on 07/19/06 21:26

(billmiami2@netscape.net) writes:
> I just ran the script generator on a single table using the SQL 2000
> option and here's what it produced:

And did you run it through Tasks->Generate Scripts? I tried to script a
single table that way, and I the script did not refer to sys.objects..

You do have SP1 of SQL 2005 installed?

I know that I've seen bug reports about script generation in this area,
but I can't recall exactly what, nor if there were any fixes in SP1.

But if the tools that Andrea pointed you to works, I guess the point is
moot by now.

--
Erland Sommarskog, SQL Server MVP, esquel@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

[Back to original message]