Answer Posted / kumar.t

EXEC sp_resetstatus 'database name'

By
Kumar.T

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1080

---

Is the order of columns in the set clause important in ms sql server?

929

---

What is the order in which the sql query is executed?

882

---

What are the characteristics of modern DBMS?

1033

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

935

---

What is a partition function in sql server?

1024

---

How retrieve field names from the table in SQL through JAVA code?

1835

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1081

---

What are different types of raid levels?

1074

---

Give a example to search fr a string in all stored procedure in sql server.

915

---

What is resultset concur_updatable?

972

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

971

---

What are indexes in ms sql server?

1000

---

How to create stored procedures with parameters in ms sql server?

993

---

What are various aggregate functions that are available?

918

---