You might have already tried this but if you have not and you do have lot of SQL Statements embedded in your Stored Procedure then one trial would be to...

Thanks every one for taking time to read the article and commenting on same.

Here are few of my thoughts.

David: Thanks for giving the inputs. The sp_ naming convention is sometimes...

Can you be a bit more specific with your problem i.e. define the kind of constraint and the table structure. Typically the Collation is not changed in such problems but...

Very Informative article.

Makes lot of sense. Thanks.

Do you have any triggers associated with this Update because at times if the trigger fails then I have come accross situations where the code seems to be working fine...

A minor modification I forgot to add space in Kill so strCommand should be like

Select @StrCommand = "Kill "+@Convert(Varchar(10),@Spid)

The Kill command in its basic form is Pre Compiled so to have it working with variable SpID , You will need to use dynamic SQL.

For eg if you...

Thanks Antares686 for your inputs Yep I guess I have only ADO as my best bet. I have used that and it seems to be working well. However I used...

Having a Identity Column does not help me as I don't have any control on the table structure. Is there any other way that we can use to solve this...

Not sure but have you tried with data in which the first row has alphanumeric element. Although not related there are many utilities and imports in which the character element...

The question is of just academic interest to me.What I am trying is very simple.I am just trying to ascertain if there is any output buffer which gets choked after...

Sorry for the delay in responding.

I could solve the problem by just changing the sequence of the cursor being opened but I still seem to be having issues with stored...

Which version of SQL Server are you using.If it is 6.5 then you cannot create and drop a temporary table in the same stored procedure and use it again.

May be...

I am not sure whether this has anything to do with your problem.In ODBC settings at the client side there is a provison to create stored procedures on Prepared statements.If...