Answer Posted / babuli

To rename a SQL database follow the these seps:

1. Alter database to single user mode. So that all the
active connection will be terminated. (Database properties
-> options > single usermode)
2. Then rename the database using sp_renamedb oldname, newname

What is server-level principal?

122

---

How do I find query history in sql server?

946

---

Create and insert into temp table in sql server?

1036

---

What is triggers and its types?

1009

---

Explain what is use of dbcc commands?

1060

---

How can you check the level of fragmentation on a table?

1046

---

List the ways in which dynamic sql can be executed?

1016

---

What is the default schema of your login session in ms sql server?

1050

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

988

---

Can you explain what are commit and rollback in sql?

944

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1010

---

How can i Relate Tables in SSIS

1082

---

application server is slow what may be the problem

2227

---

Tell me what is the significance of null value and why should we avoid permitting null values?

991

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

995

---