Symptom
Cannot rename tempdb1(temporary database). For example:
sp_renamedb tempdb1, tempdb_1
go
Msg 17793, Level 16, State 1:
Server 'myserver', Procedure 'sp_renamedb', Line 179:
System Administrator (SA) must set database 'tempdb1' to single-user mode with
sp_dboption before using 'sp_renamedb'.
(return status = 1)
1> sp_dboption tempdb1, single, true
2> go
Warning: Attempting to change database options for a temporary database.
Database options must be kept consistent across all temporary databases.
Msg 17436, Level 16, State 1:
Server 'myserver', Procedure 'sp_dboption', Line 764:
You cannot set the 'single' option for a temporary database.
(return status = 1)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
Keywords
Rename temporary database, tempdb, sp_renamedb, bind, unbind , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.