You might want to take a look at the Exchange OLE DB Provider... Here's a link from BOL that has code for accessing contacts...

http://msdn.microsoft.com/en-us/library/ms191461.aspx

-Luke.

OK I did a bit of playing and it looks like you'd need to do something like this...

DECLARE @result int; EXEC master..xp_cmdshell 'D:\TDPCDrive.bat'; IF (@result = 0) BEGIN PRINT 'Success'...

You could do it if you use semi colons to separate your statements somethign along the lines of

DECLARE @result int; EXEC master..xp_cmdshell 'D:\TDPCDrive.bat'

I'm not sure on how the IF Statement...

First off if your sql agent services are running as [Local system] you may wish to revisit that decision. There are a variety of valid Security reasons why this...

Jay,

I say there is probably something going on here with servicepack levels. The Express edition that you downloaded is most likely at SP3 if it was downloaded recently....

AndrewSQLDBA (2/26/2010)

---

No, you would want to un-install the Express edition first, do not try to "upgrade". That is the very best way to approach this issue.

You can create a backup...

I agree that this is perhaps not the best design decision. Perhaps if you're a bit more clear on what the business requirement is, we'll be able to help...

yes database mail is what you need to use to send reports from Maintenance plans and other such portions of SQL Server.

The SSRS settings only send mail from...

I'm fairly certain that you don't need Database Mail to send Mail for Subscriptions. I don't have it setup on one of my reporting servers and it sends mail...

Is your production server part of a domain? IS your test server part of the same domain?

What user installed the express instance on the test machine, the local administrator...

Some sample data and table definitions would go a long way towards helping us help you. You can check out the first article in my signature for ideas on...

Within SSRS itself this will be somewhat complex. I can see this being done a couple of ways, you could create multiple prompts, where they could enter a set...

OK so maybe this is a silly question...

If this is a clean install why install the Express version then upgrade to standard. Why not just install Standard edition from...

you have a few options...

1st you could limit the data length in your query so that you only return the first 5 letters to the Report server to begin...

OK it sounds like you have things setup correctly, or at least as far as I can tell. I believe you only need to setup the mail information in...