Have you setup a Proxy Account?

from the BOL:

When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed server role, xp_cmdshell will be executed under the...

Thanks Wes

Just to be sure, did Restoring the Backups change the collation?

I have a test environment with a different collation, & using SSCodeGen (available from this site), I...

Good Questions, I've asked them all of myself. 🙂

I split the query up into separate files to try & get the trigger in, and the other two, which...

OK, using the suggestions above, this is what I have got so far:

Declare @tmpTable table (myID int NOT NULL IDENTITY (1, 1),

Query nvarchar(4000) NOT NULL)

Declare @step int, @i int

Declare @q...

Thanks for that, I'll have a go at knocking one up. If I succeed, (and succeed I must 🙂 ) , I'll post it here.

Jacko

to that end, take a look at SSCodeGen, available on this site at http://www.sqlservercentral.com/products/SSCodeGen/

If you don't mind registering a 3rd party dll, STMAdmin, I have a bunch of scripts that reads a list of server names and gets the last two days worth...

When I worked in a support Dept., I always liked PEBKAC - Problem Exists Between Keyboard And Chair 🙂

David Jackson