Based on the original code snippet you provided, it looks to me like the .Net application is ALTERING the stored procedure, not calling it. (I believe this might be the...

If I understand your question, you are trying to query for records in which the ques.qid is found in this list of itegers: 39,40,1,4,35,41,52,54,55,56

If so, then try using dynamic SQL....

Humorous, entertaining and very informative. Thanks!:)

I don't have an answer, but this is how I would approach figuring out why the connection is failing:

1. Determine where the problem is - on the client? or...

Have you tried using SQL Server Profiler?

I think that SP:StmtCompleted might contain the detailed information showing what procedures are running, and what T-SQL statements each is executing. If you save...

I just confirmed that it is in fact possible to modify the data in views using EM (Open View from the context menu). It is even possible to modify data...

You said...  "Would like it to just delete one row of the benefit type number 2 instead of all them." If you mean that you want to delete one row...

You can use SET DEADLOCK_PRIORITY LOW to identify a transaction that should become the deadlock victim if necessary. If you have an existing deadlock situation, use sp_lock and then sp_who...

I have been reading "Step by Step: MS SQL Server 2000 Analysis Services" by Reed Jacobson, Microsoft Press. It is a very good introduction if that is what you are...

I'm a newbie, and I may be wrong but...

I believe partitioned views must have a CHECK constraint that defines the horizontal partitioning. Apparently the CHECK is actually used by the...