This only works if the server is configured correctly. If the hostname has...

I second this. Thank you!

Oh crap... I 'discovered' STR about a 18 months back and have been using it as LTRIM(STR(n)) for creating strings.

.... well, at least my old...

well.... IF I had your tasks, I would look at Redgate's SQL Compare and SQL Data compare. They will easily save you days of work.

www.red-gate.com/products/SQL_Data_Compare/index.htm

www.red-gate.com/products/SQL_Compare/index.htm

Between those...

I would also ask for current backup copies of both databases. Then you can install them on your local machine with all the power and authority you need.

You can also wrap it in a BEGIN TRANSACTION/ROLLBACK TRANSACTION like the following so you can test your script without actually making changes.

(borrowed from WayneS)

BEGIN TRANSACTION

INSERT INTO DME_ITEM (Columns to...

I have been using the free version of SQL Effects Clarity for years, especially when the databases to compare are on two different servers. They have since changed the...

after further thought, I don't like my suggestion because it doesn't work with differing lengths of items.

dbuendiab (8/11/2010)

---

Jay Hopping (8/11/2010)

---

oh, I was never pushing xml so much as saying it is possible in 2k. The only point I made about the article was that you...

oh, I was never pushing xml so much as saying it is possible in 2k. The only point I made about the article was that you could possibly check...

dbuendiab (8/10/2010)

---

Hi, Jay:

You're right, I didn't remember OPENXML. Still I would not switch to a XML-formed parameter passing for several reasons - being the main the way users like to...

dbuendiab (8/10/2010)

---

jcboyer-1091017 (8/10/2010)

---

I have been using an XML string to achieve the same results. Not sure that it is faster, but it is quite flexible as:

EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLParameters

insert...

Personally, I would lean towards a tally table approach, but I can see where the simplicity of this approach would be favorable to some of my non-sql-I-don't-want-to-touch-it-unless-I-have-to developers.

What do...

unfortunately, I have both xml and looping to handle this situation. I tend to lean towards the xml because of the flexibility and descriptiveness. The flexibility is that...

You can always use vbscript to access cdosys and the db. If you can get them to give you a simple queue table, then you can have your 'e-mails'...