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 |
|
JerrySommerville
Starting Member
12 Posts |
 Posted - 2006-08-16 : 14:11:13
|
| We have a SAN where we create a mirror of a database. Then after splitting the mirror off, we want to bring the database up on another server. We have a process that brings up the database in suspect mode. We can recover by rebuilding the logfile (dbcc rebuild_log). After resetting status we have a recovered database, but the properties of this database have the access restricted to the database owner only. This is OK, but we need to script the recovery process so I need to know what commands (or stored procedure if any) that will "uncheck" the property so all users can access the database. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 14:33:17
|
| Use ALTER DATABASE to remove this property. Check out BOL for details.Tara Kizer |
 |
|
|
|
|
|
dbo access only