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

 Last reviewed: May 2, 1997
Article ID: Q138896

The information in this article applies to:
  • Microsoft SQL Server, version 6.0

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 SSrvStProc
Version : 6.0
Platform : WINDOWS
Issue type : kberrmsg

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.