Simplest way to accomplish what you're after is to send the email to a distribution group - makes managing who receives the emails a lot simpler over time (e.g. all...

If I've read this correctly, you should also be able to recreate/reset the permissions, etc. for your reporting services instance via the Reporting Services Configuration Manager.  Go to the console,...

The process is executing on the local machine, the UNC you're using \\209.22.250.31\cmm2_bin\option4.bat is nothing more than a link network share - not a call to execute the code on another...

Is this a fresh install or an older install that used to work and no longer does?

Umm... you didn't by chance delete or move the msdb for your instance of sql server did you?

Does your username match your email address?  I've seen where the username (e.g. lastnameinitial) didn't match the email address (e.g. firstname.lastname@somewhere.com), when dealing with an exchange server it's looking...

Sounds like a good argument for a client side solution - perhaps a format on the client side?

Generall SSPI messages are related to windows authentication/integrated security... are you running as a domain user (or a non-domain user)?  Is the server a member of a domain?

Joe

One thing to check - if your SMTP server is a windows machine (e.g. Exchange/IIS SMTP) be sure that basic authentication is enabled.

The one thing to check would be the value of the username you're sending in, depending on the smtp server that may be your complete username@domainname.com or just username...

Miss -

You cannot take an entire database "back" from SQL 2005 to SQL2K - detach attach, backup/restore just won't work. 

The DTS suggestion is reasonable as long as your SQL...

Daniel -

I can think of at least one way to handle this one:

Develop your stored procedure to return the same number of fields and the same for all of your fields...

Programmer -

You probably won't see any change in the size of the .MDF file, as for the .sqb file, that sounds to me like it might be a RedGate SQL...

The question then becomes, why do you need them at all?  Does your organization have a data retention policy?  If the data is unimportant/not required for retention why not delete...