Answer Posted / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

How do I create a trace in sql server?

694

---

What do you understand by physical_only option in dbcc checkdb?

747

---

How to get the definition of a stored procedure back?

708

---

how to use DTS package in 2000,2005,2008 in sql server

1611

---

Can you name a few encryption mechanisms in sql server?

689

---

---

How do I view a trc file?

682

---

How to modify an existing user defined function?

772

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

795

---

What is nonclustered index with included columns ?

709

---

What are the difference between clustered and a non-clustered index?

757

---

how many triggers you can have on a table? : Sql server database administration

704

---

What are “phantom rows”?

1409

---

What is sql server english query?

743

---

Can group functions be mixed with non-group selection fields in ms sql server?

700

---

Using the customer, and order table in northwind database, please write a query to produce xml?

848

---