Informative article... i was not aware of the CONTEXT_INFO.

I feel that use of CONTEXT_INFO in the scripts will be creating dependencies with the developers i.e., it will be mandatory to...

Good and informative article..

But lots of typo errors... [crucial errors]

Example: "VARCHAR (MAX) or VARBINARY (MAX) can store 231 (or about 2 billion) characters. A variable declared as NVARCHAR (MAX)...

Simple and easy to understand language used... 

Good article

Hi steve..

Good information...

In addition to ROLLBACK TRANSACTION, We can also use RAISEERROR for displaying the message to the user...

Thnx.

Yes. Application name is available property.

"connStringBuilder.ApplicationName"

The details displayed are not very intutive for the user in your solution. It is better if you provide TREE like structure for your folders, which can make the users task...

You are right... RECURSION was used to solve the problem.

Still, i feel that updating thousands of rows in a single go can be easily done with XML and using database...

You can store your XML data into your database tables by defining a column of VARCHAR type.

You use OPENXML if you want to query your XML data.

thnx.

I have not tried this in a web application...

but i think it will work the same way... coz this will technique will be useful if you are calling sp's from...

oops... sorry... a mistake...

XACT_STATE states are 0,1 and -1 as you mentioned...

I used XACT_STATE in some examples and while checking for state 1, i had the condition

XACT_STATE >= 1...

XACT_STATE has 3 possible values.

0 = there is no transaction

1 = Transaction can be committed

-1 = Transaction should be rolled back.

So, if your try-catch block needs to maintain TRANSACTIONs...

Look in BOL.

U vl get detailed help with examples.

Enjoy Hunting

Hi,

I would like to know whether candidates from other countries can apply or not.

If yes, then i m interested.

http://www.sqlservercentral.com/forums/userinfo.aspx?id=234328

Hi david...

thnx for ur help again.

Have to done some querry optimization stuff.

It would be nice of u if you give me some tips for optimizing querry or even how to...

gr8 david.

thnx a lot .. it's working...