Viewing 3 posts - 1 through 3 (of 3 total)
Try this :
Install SQLServer B
launch Query Analyser on server A
execute the storedproc sp_detach_db <DB_NAME>
Copy your DB(s) to the new server (not the systems DB)
launch query analyser on server B
execute the...
June 19, 2003 at 7:38 am
#462117
Hi,
It seems that you (the logged account) can't edit the registry.
Try to install the MSSQL client tools with an account that can edit the registry (such as administrator or...
June 19, 2003 at 6:38 am
#462100
You can use TRUNCATE <tablename> to delete all records.
The identity column value is reset to 1 for the next insertion.
Claude
June 19, 2003 at 6:27 am
#462093