Detach-Attach

Can we detach and attach SQL 7.0 databases
What are options to move databases in SQl 7.0
Thanks
SanjayHi Sanjay
In SQL Server 7, detach and attach was available as stored procedures, but
not from the Enterprise Manager.
Please read about sp_detachdb and sp_attachdb in the Books Online.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Sanjay" <sanjayg@.hotmail.com> wrote in message
news:00aa01c39d72$f41b0570$a301280a@.phx.gbl...
> Can we detach and attach SQL 7.0 databases
> What are options to move databases in SQl 7.0
> Thanks
> Sanjay|||> What are options to move databases in SQl 7.0
In addition to Kalen's response, backup and restore is an option for moving
databases as well.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Sanjay" <sanjayg@.hotmail.com> wrote in message
news:00aa01c39d72$f41b0570$a301280a@.phx.gbl...
> Can we detach and attach SQL 7.0 databases
> What are options to move databases in SQl 7.0
> Thanks
> Sanjay|||In addition to previous responses you can also use DTS for
the database transformation. And in emergency cases also
BCP can be used as well.
Regards
----
All information provided above AS IS
>--Original Message--
>Can we detach and attach SQL 7.0 databases
>What are options to move databases in SQl 7.0
>Thanks
>Sanjay
>.
>