Atul,
Check out the documentation on the sp_detach_db and sp_attach_db system
stored procedures in the SQL Server 7.0 Books Online.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:> I had Installed BAckoffice. The sql version in that allows only 5
Connection. So I bought the full ver(SQL 7). I would like to know how do I
move my databse to the newer ver. or upgrade to sql7 full version.
Quote:> Atul Singh
> Network Administrator
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!