Posted by billmiami2 on 07/19/06 11:26

Andrea,

Thank you. I'll take a look.

Bill

Andrea Montanari wrote:
> 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: SQL Server 2005 Script Generation
• Prev in forum: Re: not permitted in this context
• Thread view: Re: SQL Server 2005 Script Generation

[Reply to this message]