Answer Posted / hameed

To get the description of the table execute this query in
the query editor
sp_help table_name

Explain hostprotectionattribute in sql server 2005?

1012

---

What is the difference between a view and a stored procedure?

1029

---

What is the default value of an integer data type in sql server 2005?

943

---

How to check if a table is being used in sql server?

957

---

What are the types of subquery?

1034

---

tell me the disaster recovery plan

2507

---

What does dml stand for?

942

---

What is a with(nolock)?

978

---

What are the restraints imposed on the table design by a merge replication?

1029

---

How to create a ddl trigger using "create trigger" statements?

1116

---

What do you mean by table and field in sql?

999

---

How to list all stored procedures in the current database using ms sql server?

1120

---

How to connect sql server management studio express to sql server 2005 express?

1027

---

How can sql server instances be hidden?

942

---

What is history table in sql server?

957

---