SAP Knowledge Base Article - Preview

2823191 - Unable to rename a temporary database - SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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

Search for additional results

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