Lookup REPLACE in Books Online:

SELECT REPLACE(description, 'Jasper Conran', 'JC') ...

If you still have the trace output available - search the text data for the word 'locked'. Basically, you need to identify the request that is being returned that...

The only thing I would add would be to make sure the joins are correct. Using outer joins (LEFT) will return all rows from TableA and only matching items...

I would bet anything that the...

Lynn, I knew what you meant - but, I was kinda having a bit of fun with you:

Sure, when you are creating the table, the first columns I'd define are:

ChangedBy...

Jobs run under the SQL Server Agent process, which is running under the domain account. Just because the job is owned by 'sa' does not mean it is actually...

Perry Whittle (10/27/2008)

---

you wont be able to truncate tables if there are referential integrity constraints on them (foreign keys for example)

disabling the indexes will help from a performance point and...

GilaMonster (10/27/2008)

---

Makes sense. After all, in a heap it's the RID (FileID, PageId, Slot index) that's used as the row's location in all of the nonclustered indexes. If that changes,...

Okay, now - we need to be just a bit careful with this. Found a couple of caveats we should be aware of before we start rebuilding heaps:

System tables...

Well, of course that is where it would be. Stupid me - for some reason I saw ALTER INDEX not ALTER TABLE :w00t:

That is probably your answer - the domain account has privileges on both servers and the job is running under the domain account not the 'sa' account.

Garadin (10/27/2008)

---

Considering the OP hasn't logged on in over a year, I have...

A couple of other things to simplify the queries:

1) Alias the table/view references - use aliases in select and joins

Example:

SELECT t1.col1

...

First, we can simplify your case statement with the following:

Declare @openTime Datetime;

Set @openTime = '2008-10-27 17:25';

Select dateadd(hour, datediff(hour, 0, @openTime) + 1, 0) As end_hour

...

What user account is running SQL Server Agent?