Answer Posted / swetha
sp_renamedb ?oldname? , ?newname?
alter database ?databasename?
modify name = ?newdatabasename?
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is sql server agent and what are the two modes of authentication in sql server?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
tell me the disaster recovery plan
How to stop log file growing too big?
Explain difference between control flow and data flow?
What is compound operators?
What purpose does the model database server?
Find first and last day of current month in sql server
What are the transaction properties?
How to create new databases with "create database" statements?
What is a trigger and its types?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is buffer cash and log cache in sql server?
How does normalization work?
What is the current pricing model of SQL Azure?
