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.
SAP Knowledge Base Article - Preview