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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2006-10-26 : 13:10:57
|
| Hello,Any body heard off select @@max_precision. I am trying to restoe a database,but i have got this process which is running the above procedure select@@max_precision, but each time i kill it it keeps coming back. Therefore i cannot put the database in single user mode necessary for the restore.I am using sqlserver 200 on a windows 200 machine |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-10-26 : 15:03:29
|
| @@max_precision is clearly defined in Books OnlineHave you tried the WITH ROLLBACK IMMEDIATE option on your ALTER DATABASE?Jay White |
 |
|
|
|
|
|
Select@@max_precision