Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mazdak
Yak Posting Veteran
63 Posts |
 Posted - 2002-12-01 : 07:13:55
|
| I want to use this command ina job,but it when I parse the step it gives an error:exec sp_dboption 'Test','Single User',trueerror:The following syntax error(s) were detected in the command: Error 22285: [SQL-DMO]Database 'Test' is already open and can only have one user at a time.How can I do it in a job? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-02 : 12:59:46
|
| You will need to "Kill" all users who are connected to this database before you run that command. I believe that you can find a script to do this on this site. |
 |
|
|
Mazdak
Yak Posting Veteran
63 Posts |
Posted - 2002-12-03 : 02:31:09
|
quote:
I believe that you can find a script to do this on this site.
Would you suggest me a keyword to search? |
|
|
|
|
|
|
Database options in job