I have had a similar message before.  I would try the following:

xp_stopmail

xp_startmail

And see if that works.  If not, I would be interested to see if anyone else has experienced this...

Sounds simple, but have you checked the path?  I just ran a quick test with the following syntax, and it seems to work fine.  Are you getting any errors?:

exec master..xp_sendmail...

Search for "xp_sendmail" in books online and it will give you the list of parameters.  The @attachments parameter can be set to create an email attachment.

Hope this helps!

thanks for the info.  I have read that KB article, however, it is specifically talking about BCPing WITHOUT the check constraints option.  I have no problem using the check constraints...

Thank you all for your responses.  Statistics were recompiled.  Did not think of the order by clause in the view.  I will give that a shot as well. 

As far...

Hi EdMann,

To answer your question the query with variables has been in production for at least 1 year.  Also, there is datagrowth in the tables, but it has been about...

Should have mentioned - SQL 2000 on W2K03. 

Thank you for your response.  Actually after I made the post, a colleague of mine had mentioned just that.  We hypothesized that a process needed a certain amount of space, however,...

You can call an oracle stored procedure from sql.  I do it in a DTS package.  I create a connection to Oracle using the Microsoft ODBC driver for Oracle.  I...

I should have included some of the specs

Clustered SQL Server 2000 sp3a

Windows 2003

thank you all for your responses.  Setting the -g startup parameter and failing the cluster over seems to have resolved the issue. 

ajroney

Thank you for the response!  Even though I emphatically stated it was not an access issue, it turned out that it was.  The user I gave rights to was logged...

Thank you for all the responses!

Thanks for your response.  Leads me to believe that SQL 2000 cannot encrypt data internally.  If anyone knows otherwise, please fill me in.

Thanks,

AJR

Chris, DTC is setup during the cluster install.  In addtion to rebooting our nodes (I just found this out) we also set a dependency between DTC and the SQL Service...