SAP Knowledge Base Article - Preview

2823191 - Unable to rename a temporary database - SAP ASE


Cannot rename tempdb1(temporary database).  For example:

sp_renamedb tempdb1, tempdb_1

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)



SAP Adaptive Server Enterprise (ASE) all versions


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.