Reply to Re: SQL Server 2005 Script Generation

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация