Well if a spid is stuck directly related to the SP your option is to kill or restart (you could also throw the users out of the DB with single...

Can you post details of what you tried?

RIght off I don't see anything specific. However try removing the return at the end as it isn't needed for your case and see if maybe that is someho related???...

Only thing i can think of is ROWLOCK but that won't keep people out of the table in addition to the row, just the row.

Locking Hints

A range of table-level locking...

Sorry apparently they track requests to the KB section. Follow that link and in the search box type

crystal reports unicode characters

and press go then press to search with omitted...

Here try this to pull from the KB articles for Crystal related to your question.

http://www.businessobjects.com/search/?q=crystal+reports+unicode+characters&filter=0&restrict=www&ie=utf8&website=&site=my_collection&output=xml_no_dtd&client=my_collection&access=p&lr=lang_en&ct=livewww-all&summary=1&proxystylesheet=my_collection&oe=utf8&num=&start=

BULK INSERT, bcp and other bulk transactiona like that.

In times like that you should use Profiler to watch what happens with the cache and the plan for the IIS calls and your own. I the logic is wrapped...

Some traces are directed to the SQL Server Logs. I do believe 1794 may be one of those.

In the previous code change this

IsNull(S1.CancelDate,'19000101') < S2.SaleDate

To This

S1.CancelDate < S2.SaleDate

And try again.

If the box was set up as default and you didn't change any security logins then anyone in the NT admin group on that server can get in the SQL...

From what I recall SUBST only is visible to the logged in user. SQL doesn't run under the same user context as the logged in user so SQL depednign on...

If using SQL 200 then simple create a USer Defined Function to lookup the previous value like so.

CREATE FUNCTION dbo.PreviousLot (@Cust_ID int, @Cur_Lot int)

RETURNS int

AS

BEGIN

 DECLARE @chkLot int,

  @chkDate datetime

 SELECT

  TOP 1...

Personally I prefer to use multipls SPs in groups with chekcing logic in first, update in another and insert in yet another so I get an execution plan for each...

I have used this before on simpler issues but this is how you do what you are asking.

Simple do like so.

SELECT

 [id],

 MAX(CASE ques_name WHEN 'date' THEN ques_val ELSE null END) AS...