Saving SQL 2000 Databases in SQL 7 format

Hi
I understand 2000 databases are not backward compatible
but is there any way to save 2000 databases in 7 format?
Is there an option?
Thanks
TonyHi,
You can set the user databases to SQL 7.0 compatible in SQL2000. You can do
that using Enterprise manager as well as Query Analyzer.
Enterprise manager:
1.Expand databases -- Right click and select properties
2. Choose option tab -- In the compatibility combo box select "Database
compatibilty level 70"
3. Click ok
Query ANalyzer:
1. Execute the below script.
EXEC sp_dbcmptlevel 'pubs', 70
Thanks
Hari
MCDBA
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:298601c4709c$5dc1af40$a401280a@.phx.gbl...
> Hi
> I understand 2000 databases are not backward compatible
> but is there any way to save 2000 databases in 7 format?
> Is there an option?
> Thanks
> Tony|||What exactly do you mean by "Save"? Do you want to know how to get it into
a 7.0 db or did Hari address your issue?
Andrew J. Kelly SQL MVP
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:298601c4709c$5dc1af40$a401280a@.phx.gbl...
> Hi
> I understand 2000 databases are not backward compatible
> but is there any way to save 2000 databases in 7 format?
> Is there an option?
> Thanks
> Tony|||Tony,
To add to Andrew's post, if you want to export data from 2000 to 7, then
you can use DTS.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Andrew J. Kelly wrote:
> What exactly do you mean by "Save"? Do you want to know how to get it int
o
> a 7.0 db or did Hari address your issue?
>