Q.What is the new error handling technique in SQL Server 2005?
A.Previously, error handling was done using @@ERROR or check @@ROWCOUNT, which didn’t turn out to be a very feasible option for fatal errors. New error handling technique in SQL Server 2005 provides a TRY and CATCH block mechanism. When an error occurs the processing in the TRY block stops and processing is then picked up in the CATCH block. TRY CATCH constructs traps errors that have a severity of 11 through 19 as well.
A.Previously, error handling was done using @@ERROR or check @@ROWCOUNT, which didn’t turn out to be a very feasible option for fatal errors. New error handling technique in SQL Server 2005 provides a TRY and CATCH block mechanism. When an error occurs the processing in the TRY block stops and processing is then picked up in the CATCH block. TRY CATCH constructs traps errors that have a severity of 11 through 19 as well.
Q.What exactly is SQL Server 2005 Service Broker?
A.Servive brokers allow build applications in which independent components work together to accomplish a task. They help build scalable, secure database applications. The brokers provide a message based communication and can be used for applications within a single database. It helps reducing development time by providing an enriched environment.
A.Servive brokers allow build applications in which independent components work together to accomplish a task. They help build scalable, secure database applications. The brokers provide a message based communication and can be used for applications within a single database. It helps reducing development time by providing an enriched environment.
No comments:
Post a Comment