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 for Me (Login required).

Search for additional results

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