Change Database Name-Sql

Posted Date: 07 Oct 2009	Resource Type: Code Snippets	Category: SQL
Author: priyaravi	Member Level: Silver
Rating:	Points: 2

The following code snippet demonstrates how to change the DataBase name in sql server


Exec sp_renamedb ‘olddbname’,’newdbname’


exec sp_renamedb 'tab1','tab2'

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Sql database name .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Store Procedure to be Used in Custom Pagging
	Previous Resource: To find keywords in SQLServer Functions & stored Procedure
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

More Resources

Store Procedure to be Used in Custom Pagging
Sql Replace Function
Recursion in SQL 2005
Parse XML Data in SQL Server 2005 without using OPENXML Method
How to set default value for existing datetime column in SQL Server
To Unlock Particular User in Sql Server