Answer Posted / muruganandam05

In this The Administrators can use to access a running
server even if the server is locked or othervise
unavailable .This capability enables administrators to
troubleshoot problems on a server by executing diagnostic
function or Transact-SQL-Statements.

Can you leave a union at any time?

1004

---

What is b tree index?

859

---

What does executeupdate return?

929

---

What is the command dbcc checkdb used for?

966

---

How to find tables without indexes?

1032

---

What is cursors?

1096

---

What are the different editions available in sql server 2000?

995

---

What are the advantages of using third-party tools?

921

---

How to run queries with sql server management studio express?

1022

---

How do I find the size of a sql server database?

878

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2714

---

Difference between 2NF &3NF ?

1029

---

Can foreign key be duplicate?

1002

---

What are the types of table?

921

---

Where can you find the error log information? : sql server database administration

972

---