Answer / Priyanka Suman

Changing the database name in SQL Server requires a server-level permission. Here's a step-by-step guide:n
1. Open Object Explorer in Management Studio.
2. Right-click on the Databases node, then select Tasks > Change Database Name...
3. Enter the new database name and click OK.

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

What is a join in sql?

1 Answers  

---

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

1 Answers  

---

Why Master database is required?

1 Answers   Abacus,

---

Explain multiserver query

1 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

What is the difference between osql and query analyzer?

1 Answers  

---

Explain the difference between primary keys and foreign keys?

1 Answers  

---

Tell me what is the order in which the sql query is executed?

1 Answers  

---

what are user defined datatypes and when you should go for them? : Sql server database administration

1 Answers  

---

What is a unique key constraint?

1 Answers  

---

What is the use of set nocount on/off statement?

1 Answers  

---