it's not clear what you are after; if you run the code, it's going to produce results like this:

<li>Bob Smith</li><li>Bill Smith</li><li>Bill Jones</li><li>Bob Jones</li>

you did run the code, right? you know...

well too bad about no date so we can't keep the last x months of data; but assuming we can delete all but one(the highest ImageID) for each customer, here's...

pretty sure it's simply changing the one parameter to true:

@useself=N'True',...

in that case, the logged in users credentials would be passe dot the linked server, and it would work/fail if they...

no...i really need you to actually script out the table; pseudocode doesn't help...for example there is no "blob" data type in SQL ...it could be TEXT/IMAGE/varbinary(max), for example;

Also I ...

can you show us the table definition that contains the blobs? ie CREATE TABLE....

if there is a column in the table that has the date in it, you should be...

ok how about this:

first that other cursor has a logic hole; don't loop thru databaszes, loop thru connections.

i adapted my sp_kill function, which is database specific, to do the whole...

it's this part:

select

@msg = @msg + 'New Item ....FROM INSERTED

if inserted has 10 rows, @msg is going to have 10 "lines", one for each...

aww, you didn't answer any of my questions....

well, i'm expecting the followup post that says "help i deleted 2000 jobs and now i need some of them back"

did you backup...

it's up to you; you can combine the functionality in the same trigger.

I'd just make a second trigger, but it is up to you.

i noticed your trigger will not send...

I'm curious; someone went to a lot of trouble to create 2000 jobs. what is your reason for wanting to delete them now? are you replacing them with something new?...

well, somehwere in your code, you have these two variables declared; just change their definition to a bigger value:(and make sure @msg is HUGE to hold the concat of these...

looks like it's just a syntax error because of some double quotes; the double quotesd belong inside the single quotes to create the string.

assuming you wanted double quotes around the...

also, isn't the implicit conversion of left(getdate() -1,11) dependent on the servers regional settings? I think that makes an assumption on the regional settings that might not be true...

usually, linked servers do not allow DDL commands; only DML insert/update/delete/select.

AFAIK, you can't even create temp tables on a SQL linked server, fir example, which i would think would be...

no, sorry.

the intellisense works only using 2008 client tools connecting to a 2008 instance; the same tools, when connecting to a pre-2008 instance do not enable themselves.