Yes.

-- Create temp table to hold the xp_cmdshell results

IF OBJECT_ID('tempdb..#tbl1', 'TABLE') IS NOT NULL

DROP TABLE #tbl1

CREATE TABLE #tbl1 (Idx INT IDENTITY(1, 1),...

I think that there are simpler solutions. Does this table have an identity column? If not, you can use the technique below. It's pretty straightforward. If it does, just skip...

I apologize if my posting implied that it was a terrible script. This was not my intension. Sorry. I only really skipped through some lines of codes in the script...

You can easily compare binary streams that are the result of the conversion of the original text vs. all-upper-case text.

SELECT MyCol

FROM MyTable

WHERE CONVERT(varbinary(8000), MyCol) CONVERT(varbinary(8000), UPPER(MyCol))

MyCol is the column...

In the link that you posted, it's annoying that MS doesn't tell you the reason for the issue and just says to upgrade to SP4... oh well... Lets try to...

How about:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

BEGIN TRAN

SELECT MyCol1, MyCol2, ...

FROM MyOwner.MyTable WITH (ROWLOCK)

INNER JOIN MyOwner1.MyTable1 WITH (ROWLOCK)

ON ...

-- At this point all is locked.

IF...

I saw your replies in other threads and was sure that my proposed solution was way too basic Was worth the shot...

The only...

1. Are web users getting Connection Timeouts or Execution Timeouts? The two are different.

2. In the meantime- can you just update your web.config to allow greater timeouts?

3. What control do...

Are you working in a workgroup or in a domain? Looks like you're trying to link between the two servers using NT authentication. Is that indeed the case? If you...

Longshot- is there a chance that the job is configured to report success even though it failed? i.e., is it possible that the "On failure action" is "Quit the job...

Can you please post your code here and highlight the part in the code that causes the error? I can then show you explicitly what I mean by the above...

Is there any chance that some of your object names, index names, (etc.) contain spaces or single upper quotes?

It's not a very well written script. It doesn't take into account...

The problem is with the IN command. IN clause can be interpreted in many ways and had a lot of problems in SQL 2K. That is why (I imagine) it...

The only way I am familiar with is to put your SQL statement inside an EXEC() or sp_executesql statement. There is no direct way of telling SQL server to not...

The trigger is a child object of the table. The name of the trigger can be obtained from within the trigger using @@procid. In other words, you can get the...