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)

What happens when the SQL Azure database reaches Max Size?

107

---

How to enter comments in transact-sql statements?

893

---

Explain how you can configure a running aggregate in SSRS?

155

---

Does view occupy space?

885

---

Explain the difference between HTTP and HTTPS in database?

974

---

What is the use of sign function?

1033

---

where can you add custom error messages to sql server? : Sql server administration

1046

---

How will you monitor replication latency in transactional replication? : sql server replication

1087

---

How secure is sql server database?

954

---

Which tcl commands are available on the sql server?

1016

---

Explain tables in SQL Azure?

120

---

What are logical/boolean operations in ms sql server?

978

---

Explain transaction server auto commit?

988

---

Mention the uses of stored procedures.

927

---

Explain the first normal form(1nf)?

967

---