Toby White (3/18/2010)

---

2 points 2 easy. One complaint - your language in the question and for the answer was imprecise. In your answer you said something about basically waiting for...

Lilita (3/15/2010)

---

sorrY

It didn't help

I run job and get

Executed as user: sa. Could not obtain information about Windows NT group/user 'usr_testmail', error code 0xffff0002. [SQLSTATE 42000] (Error 15404). The...

tferguson (3/16/2010)

---

Neat concept, but did you consider that since you've added a linked server to connect to your 2005 instance, anyone with a login on the 2000 instance now can...

Lilita (3/14/2010)

---

Hi,

I read the link you advised me.

Thank you

I tried to connect to server 2000 with sa

and run the ...msdb.dbo.sp_send_dbmail ...

I get the same error: "Could not obtain...

CirquedeSQLeil (3/9/2010)

---

Thanks for the article. Unfortunately there are plenty of 2000 servers still in production (75% of mine are 2000). It was quite a refresher course when coming...

Lilita (3/11/2010)

---

I tried it from Query window.

I always test my scripts in Query Window before job's creation.

I suppose your code must work from Query Window too.

I have permissions...

Lilita (3/10/2010)

---

when I try this idea, i get the error

Msg 15404, Level 16, State 10, Line 1

Could not obtain information about Windows NT group/user 'usr_testmail', error code 0xffff0002.

'usr_testmail' - is...

jinlye (3/9/2010)

---

SQL 2000 SP4 drops out of the extended support phase in April 2013. After that MS won't be doing any security patches, so security holes won't get fixed...

GTR,

Thanks for sharing, that was easy

GTR (3/9/2010)

---

Could you kindly run me through this on where exactly to change this. I am a bit lost.

mtassin (3/9/2010)

---

Why not just use something like CDO or if your server is old enough CDONTS?

Basically brings Database Mail to SQL server 2000. Just for fun I was creating sp_send_dbmail...

dawidjordaan (3/9/2010)

---

This is a great article. Do you have any comments on the security side of things here? We have to follow the CIS procedures that 'outlaw' SQL Mail. Does...

Hi VK,

I wrote this because most of my colleagues are still working on...

Thanks for sharing the article link.

I also came across another URL on BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/bb95ecaf-444a-4771-a625-e0a91c8f0709.htm

which describes using DTA against a test server instead of directly on production.

By any chance, have you...

CirquedeSQLeil (3/8/2010)

---

Use DTA with extreme caution. Not all indexes and statistics suggested are viable options. I would certainly start with running this in a test environment first. ...