Answer Posted / savitha

2005sqlser support try catch which is not possible in 2000
In SQL Server 2000 , a row cannot exceed 8000 bytes in
size ... To solve this problem, Microsoft introduced the
VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types
in SQL Server 2005. These data types can hold the same
amount of data BLOBs can hold (2 GB)

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1111

---

What is the benefit of normalization?

1061

---

Why do we use stored procedures in sql server?

924

---

can SSRS reports Cache results?

147

---

What is use of @@ spid in sql server?

1197

---

What do you understand by the denormalisation?

937

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

940

---

Explain the rules for designing files and file groups in sql server?

968

---

How to list all tables in the database using odbc_tables()?

1030

---

What is order of B+tree?

1095

---

Working with TLogs

1822

---

Are semicolons required at the end of sql statements in sql server 2005?

965

---

What is save transaction and save point?

1175

---

How to create view in stored procedure sql server?

1003

---

How do I create a stored procedure in dbml?

988

---