You can also change the VB code to pass in nulls for those parameters, but what you are doing works.

You don't mention if you corrected the issue(s) in the WHERE...

This is...

I wouldn't say that there is anything wrong with it. I'd do it something like this:

[font="Courier New"]YEAR(GETDATE()) - YEAR(birthdate) - CASE  

                                       WHEN MONTH(GETDATE()) < MONTH(birthdate) THEN 1

                                       WHEN...

Can you post the backup command you are running? Obviously you can change names if necessary.

Also, what is the error you are getting?

I have solved many problems by walking to a co-workers desk and asking them what they think and by the time I'm done explaining I have found a solution. ...

That would make sense since Database Mail is smtp and SQL Mail used MAPI and was connected to your Exchange Server using Outlook.

Assuming that you are scheduling these backups does the SQL Agent Service account have rights to the share?

That's an interesting question because it depends on what you expect row 10 to be. SQL does not guarantee order unless you specify an ORDER BY. In most...

Here is the best way I have found to use smtp in SQL Server 7, 2000. Download, install, and use xp_smtp_sendmail. Here's the link:

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

To backup to the network you should use UNC paths (\\server\share) not mapped drives. Drives aren't mapped unless you are logged in to the console so SQL Server never...

Why can't you run a server-side trace? The impact is minimal if you limit events and columns returned and put a filter on.

You could also put a RaisError() with...

I think that is the key line in the error...

I don't disagree and I have read many posts/articles/editorials about these issues. The biggest problem is that hiring managers only see resumes AFTER HR has culled them based on...

Duplicate post. Other one found here: http://www.sqlservercentral.com/Forums/Topic556124-1063-1.aspx

How are you getting the results into the email? Are you attaching query results? Please post your current code. My best guess is that you would have...