Answer Posted / guest

sp_helpdb , sp_who2, sp_renamedb are a set of system defined
stored procedures. We can also have user defined stored
procedures which can be called in similar way.

What is built-in function?

1006

---

What are the different Topologies in which Replication can be configured?

1183

---

How can windows applications connect to sql servers via odbc?

1128

---

Describe triggers features and limitations?

989

---

Do you know hot add cpu in sql server 2008?

952

---

Explain what are various ways to enhance the ssrs report?

1044

---

What to perform pattern match with the like operator?

883

---

Why is sql server log file full?

1036

---

What is create statement?

954

---

What is normalization of database? What are its benefits?

1026

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

958

---

What do I need to start working with sql studio? : sql server management studio

1118

---

What is GUID in sql server?

1165

---

Explain about sql server login?

1086

---

What is the xml datatype?

1073

---