Running SQL SERVER 2000.
There is one mdf and ldf file I want to detach and move and attach .
I have some experience with SQL server 2000 .
Let's call the mdf file A.mdf and the log file is Alog.ldf The name for the sql server instance is 'A200'.
Could you please write a simple script showing:
How to set A.mdf into single user mode.
How to detach A.mdf
How to attach A.mdf which is now in folder c:\A200Storage
Once the database A.mdf is attached, what commands will remove single user mode from A.mdf so it can be used by many users?