Re: Management Studio scripts for SQL 2000
- From: Darren <Darren@xxxxxxxxxxxxx>
- Date: Thu, 18 Jan 2007 10:14:41 -0800
Thanks. I wasn't aware of SP1.
Erland Sommarskog wrote:
Darren (Darren@xxxxxxxxxxxxx) writes:.When I use the generate scripts task in Management Studio to create tables
for a SQL 2000 target, the scripts do not run in SQL 2000.
Exactly why do they not run? Because they refer to sys.objects, of because
of some other problem? I just scripted a database on SQL 2005 for SQL 2000, and the script ran on SQL 2000.
I seem to recall that that there was a problem with scripts for SQL 2000
referring to sys.objects in the RTM release ot SQL 2005, but this was
corrected in SP1. You can find SP1 of SQL 2005 at
http://www.microsoft.com/sql/sp1.mspx.
- References:
- Management Studio scripts for SQL 2000
- From: Darren
- Re: Management Studio scripts for SQL 2000
- From: Erland Sommarskog
- Management Studio scripts for SQL 2000
- Prev by Date: Re: beware: SQL2005 management studio not 2000 compatible
- Next by Date: Re: Migrate from Sybase SQLAnywhere
- Previous by thread: Re: Management Studio scripts for SQL 2000
- Next by thread: beware: SQL2005 management studio not 2000 compatible
- Index(es):
Relevant Pages
|
