What command do we use to rename a db?

Answer Posted / latha sree

sp_renamedb ?oldname? , ?newname?

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know clustered and non-clustered index?

535


How to generate create table script on an existing table in ms sql server?

654


What is the default port for SQL Server over a firewall?

595


Which rendering formats are affected by the pagesize properties?

106


When I run the sql server 2000 setup, it just hangs. What do I do?

658






Explain the purpose of indexes?

552


What happens if strings are casted into wrong code pages in ms sql server?

577


What is use of except clause?

637


What is the size of transaction log file?

501


How do you implement session management in SQL Server mode?

566


Is the order of columns in the set clause important in ms sql server?

526


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

579


What is sql injection and why is it a problem? : sql server security

576


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1585


What is temporal table?

492