Posted by Andrea Montanari on 07/19/06 10:37

hi Bill,
billmiami2@netscape.net wrote:
> 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.

try having a look at http://www.sqlteam.com/publish/scriptio/ and or my
amScript at http://www.asql.biz/en/Download2005.aspx
they are both free..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

• Next in forum: Re: not permitted in this context
• Prev in forum: 2005 Express Edition: installing full-text search
• Thread view: Re: SQL Server 2005 Script Generation

[Reply to this message]