Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2476

---

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.

2720

---

Scalability, Availability, Integration with internet, etc.)?

2839

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1958

---

If a stored procedure is taking a table data type, how it looks?

6372

---

Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component

2437

---

What tags do you need to add within the asp:datagrid tags to bind columns manually.

1899

---

what user controls are and what server controls are and the differences between the two.

1995

---

If we write any code for DataGrid methods, what is the access specifier used for that methods in the code behind file and why?

2049

---

How will you load dynamic assembly? How will create assemblies at run time?

2097

---

Describe the Managed Execution Process

2102

---

What is the new three features of COM+ services, which are not there in COM (MTS)

1928

---

Is the COM architecture same as .Net architecture? What is the difference between them (if at all there is)?

1968

---

Explain grouped cross tab?

2578

---

Explain reference cursor?

2125

---