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"...

SQL server handles concurrency for you automatically, even if your two users were to try to delete each other at the EXACT same millisecond, SQL will determine that one of...

i don't remember the scripts coming out in order, I'm testing it now...the wierd thing is, on a decent size database, with 2000+ objects, it's still running the Script wizard...

if you add a server side trace, then you can use the HOSTNAME column, which resolves to the computername that connected, in the trace to track everything from that PC.

you...

do you mean a temp table on the linked server? like this?

Select * into "server2".dbname.dbo.tablename from tablename

"The object contains more than the maximum number of prefixes. The maximum is 2."

If...

the piece you posted does not have an ORDER BY, without it, the data comes back in whatever order is convenient for SQL server to get the data.

The piece...

a couple of people noticed they registered themselves twice...could that be your issue as well?

if you joined, then joined again, your first "original" account keeps the first name, but all...

Magy i may have read the requirement wrong, but all i did was wrap your query with parenthesis, give it an alias, and add the grouping...is that what you wanted?

SELECT...