Can I use SQL 2005 script to create SQL 2000 database?

Can I use a script generated in SQL 2005 to create a database on a SQL 2000
server?
We're migrating from SQL 2000 to SQL 2005, and at the same time doing a
major upgrade to an existing SQL 2000 database. Another group created the
new database in SQL 2005 on a remote test server. I connected to the test
server and generated a script to recreate the database on another server
running SQL 2000.
Any help would be appreciated.
John
John,
As long as the script does not use any 2005 features it will work fine. But
if that was not thought about at script generation, then you may have a few
problems.
If you use the scripting tools in SQL Server Management Studio 2005 to
create a script from a database on a 2005 server, you will see that you can
choose the option to create a 2000 or a 2005 script. They are a little
different, so if that is how they generated your script, perhaps they can
(re)generate using the 2000 format.
RLF
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:BD83397B-F6A9-4153-ABCF-9E84D2E7AC5D@.microsoft.com...
> Can I use a script generated in SQL 2005 to create a database on a SQL
> 2000
> server?
> We're migrating from SQL 2000 to SQL 2005, and at the same time doing a
> major upgrade to an existing SQL 2000 database. Another group created the
> new database in SQL 2005 on a remote test server. I connected to the test
> server and generated a script to recreate the database on another server
> running SQL 2000.
> Any help would be appreciated.
> John
|||Thanks for the quick reply, Russell. I'll let the other group know to
regenerate the script for 2000.
John
"Russell Fields" wrote:

> John,
> As long as the script does not use any 2005 features it will work fine. But
> if that was not thought about at script generation, then you may have a few
> problems.
> If you use the scripting tools in SQL Server Management Studio 2005 to
> create a script from a database on a 2005 server, you will see that you can
> choose the option to create a 2000 or a 2005 script. They are a little
> different, so if that is how they generated your script, perhaps they can
> (re)generate using the 2000 format.
> RLF
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:BD83397B-F6A9-4153-ABCF-9E84D2E7AC5D@.microsoft.com...
>
>