I had problems initially configuring my email to interact with a similar circumstance.

I tried sp_send_cdontsmail, sp_send_cdosysmail and some other sp_sendmail with out much success.

I then tried using xpsmtp80.dll for...

It might be looking for a var that was not supplied.

Can you provide your email code?

In a perfect world….I would like to create an index on a computed variable. We use a lot “check digits” binary numbers throughout our stored procedures.

Example:

Begin select @bCount =...

Check out:

http://www.quest.com/spotlight_weblogic/pdfs/Spotlight_Weblogic_DS_2004.pdf

I have a similar problem. It has to be instlled ny a "Admin" on the server, however you can set it to notify via email any alerts...

Check out: http://www.windowsitpro.com/Article/ArticleID/20534/20534.html?Ad=1

Take a look at:

http://www.extremeexperts.com/sql/scripts/SaveOutput.aspx

Look at

http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/

Check this out for some tips.

http://www.windowsitpro.com/Article/ArticleID/26244/26244.html

HTH

Marty

The clustering option ensures that the data in the table is part of the index, which enables quick search and retrieval.

Also a  clustered key is best used to support queries...

Go to http://www.nigelrivett.net/SQLTsql/TableNameAsVariable.html

Have you tried SQL Profiler or Trace Flags?

Marty

Or else just use xp_cmdshell and specify the network path to your file

I have never used it,  however I think there is a procedure: xp_fileexist that might work.

Would not someting like

SELECT Distinct TableA.one, TableB.one

FROM TableA, TableB

Yes there is,  try using xpsmtp80.dll.

It can be found at:

http://www.sqldev.net/xp/xpsmtp.htm

Marty