INF: SPs & Views Can Run in Read-Only DBs After Load

Q138896

The information in this article applies to:

SUMMARY

In previous versions of Microsoft SQL Server, any attempt to execute a stored procedure or view in a database marked as "read-only" immediately following a database load would result in the following error:

Msg 3906, "Attempt to BEGIN TRANsaction in database '%.*s' failed because database is READ ONLY."
This error was expected and by design of the product. Beginning with SQL Server 6.0 Service Pack 2, you will no longer encounter this error when executing a stored procedure or view in a read-only database after a database load.


MORE INFORMATION

This enhancement will benefit customers who need to execute stored procedures and views on "hot" backup servers. Currently, the concept of a "hot" backup server requires that the database be marked as "read-only" using sp_dboption. See the SQL Server 6.0 "Administrator's Companion," Appendix E, "Backup and Recovery Guidelines for Production Environments" for more information on setting up "hot" backup servers.

Additional query words: sql6 sp windows nt errmsg

Keywords : kbusage
Issue type : kbinfo
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600


Last Reviewed: March 30, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.