Answer Posted / karthick.r

sp_rename olddatabasename newdatabasename
for eg
sp_rename prodetails empdetails;


in this eg the name of the prodetails is changed into
empdetails using above command

How do I save a stored procedure in sql server?

1003

---

What is temporary stored procedure?

953

---

role of sql sever 2005 in database rather than any other database

1947

---

Is it ok to shrink transaction log?

1009

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

969

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1045

---

What is a View ? Can we insert, Update and delete a view?

998

---

Mention the different authentication modes in sql server.

1063

---

How to create a new table in a given schema?

1193

---

How does index makes search faster?

982

---

Explain the usage of floor function in sql server.

968

---

What are the requirements on sql server network connections?

1005

---

Explain about integration services of Microsoft SQL server?

1040

---

explain different types of constraints? : Sql server database administration

960

---

How to find tables without indexes?

1090

---