that's the old, deprecated syntax to designate outer joins:

--AND R.Code = W.TransactionType is the same as

FROM R INNER JOIN W ON R.CODE = W.TransactionType

--AND R.Code *=...

most mail servers allow relaying only for two conditions: if your IP address is on the same subnet as the mail server, ie the internal IP to your mail...

what does "sychronize" mean to you?

can you just take the backup at ServerA and restore it at ServerB, or does each server have data that their opposite server does not...

Wayne what you are after is stored in the registry, and it depends on which verison of SSMS you are using for the exact key;

the lazy way is to regedit...

i mistook the requirement to be info in @@Version, to see if it was Express/Workgroup/Standard/Enterprise/Developer that had been using the file.

i don't believe this is possible;

i was under the impression that the mdf is a standard file format for each version(2000/05/08)...meaning that all versions of SQL save to the...

i was a little unsure on which to select; his thread title said "Select tbl1.a if exists otherwise tbl2.a",

and i glossed over the implication that whether tbl1 or tbl2 =...

-- COALESCE returns the first non-null value from the list provided; it is a param array, so an large number of arguments can be passed to check for non-nulls.

SELECT COALESCE(tbl1.a,tbl2.a,'no...

i suspect you need to use ISNULL for each of your columns, right?

concatenating NULL to anything is null, so i think that's the problem:

DECLARE @tableHTML NVARCHAR(MAX);

SET @tableHTML =

N'<H1>Hot Item(S)...

you don't really print results; you'll want to toggle between grid mode and text mode to get the results you want.

in SSMS click control + t to switch to text...

also, isn't your UPDATE statemnt in a non-SQL server format?

i'd think it should be something like this:

UPDATE p.dbo.B

SET hotflagemail = 1

WHERE isnull(available_qty,0) = 0

AND isnull(available_qty_temp,0) = 0

AND...

exec sp_tables_ex MyLinkedServer will show you all the tables in the linked server that you can directly access; from there it's things like select * from MyLinkedServer...Tablename, and you might...

Paul thank you so much for providing the code you were trying to use; it gave me everything i needed to try and look at the issue. Since this was...

no it's not possible; the html textbox item itself does not support internally changed fonts;

you could use a <span> tag instead of a textbox, that would allow you to put...

some errors are driver specific; your error said this specifically: spaces, tabs, or carriage returns as delimiters.

my code obviously had lots of CrLf's for readability; can you jsut add a...