Posted by billmiami2 on 07/18/06 21:09

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.

Bill E.

[Back to original message]