duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

Linked...

it's the actual physical address: i think the format is [file_id]:[page_id]:[slot_id], so it's the true physical address on your server;

ar-727381 (9/25/2009)

---

i already have this table created. i just gave you the top few rows of it. I dont think i can update the table with %%LockRes%%

so will...

ok here's a 2005 secret: there is a hidden row identifier in every table row named %%LockRes%%,

in 2008 they renamed the identifier to %%physloc%%

you can use that as part of...

as you know SQL backs up whole databases, so your options are:

-- a not "real" SQl backup: send the DDL and the data to a text file via BCP, so...

yes...because the test is HAVING COUNT(RT_MCP_Alarm_Text) >= 1, it probably sends for testing purposes...change it back to 30, and it won't until you finally have 30 or more messages and...

that looks more like an error from running the script on the wrong database.

if the original SQL you pasted was valid, the rest should be valid too...

what you pasted is...

brian yes, that is exactly how i would do it;

to test it, simply run the sql inside the EXISTS() portion....it probably returns nothing, so change the HAVING to1 instead...

i know it's kind of repetitive, but htis is how i've done it...use an exists to test for the condition, then the query to build the email, same as you've...

BCP or BULK INSERT are a couple orders of magnitude faster than getting the data from a linked server; is that how you are getting the data from the 2005...

just noticed that you posted in a 2000 forum: the solutions is still the same, just a different table to get the data, plus you will be handicapped because syscomments...

Chuck's idea got me thinking....his requirement obviously was more expansive, but i justed tested this solution below, and it strips out all the comments; so if you use the results...

ok, again, if you had provided the full DDL of the tables and sample data, this would have been easier...i think you changed from id_Member being an int to being...

to clarify, if the above SELECT returns a row, you were allowed to delete the member, if it does not, noone would be deleted.

i kinda need some sample data to see if i have the logic down right;

ok, here is how i would do it:

i have a sub select below of every "admin"...