Posted by Erland Sommarskog on 07/18/06 21:14

(billmiami2@netscape.net) writes:
> I recently generated a script using SQL Server 2005 for a local
> database that is configured as SQL Server 2000. Nevertheless, the
> script used the new structures and syntax (i.e., sys.objects vs.
> sysobjects). Is there a way that I can force SQL Server 2005 to use
> the old 2000 syntax? I notice that when I script objects on a remote
> SQL Server 2000 machine, it does use the old syntax.

If you use Tasks->Generate Scripts you will arrive at an options dialog
where you can select SQL 2000 syntax. If you script individual objects
directly from Object Explorer, there is no way to set options.


--
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

• Next in forum: Re: quicker way to create indexes
• Prev in forum: Re: Terminal Service Manager
• Thread view: Re: SQL Server 2005 Script Generation

[Reply to this message]