Is the executable going to be a GUI app or command line only?  Your call to notepad.exe most likely worked but never ended because it is not self terminating.  Try...

Don't the compare tools from ApexSQL and RedGate compare views as well?  If so, you could turn your queries into views and compare them.  All of these views could actually...

We did not ever solve it (even with Microsoft looking into it).  We did implement a workaround though by using a LinkedServer from the affected servers.  We then changed that...

Any Suggestions?

This issue sounds like it is on the SMTP side similar to what we had and my last company.  We could sent any internal emails that we wanted from any...

Here is what we are currently doing to convert run_date and run_time to a datetime field:

SELECT substring(CONVERT(VARCHAR, sjh.run_date),5,2) + '/' + substring(CONVERT(VARCHAR, sjh.run_date),7,2) + '/' +

 substring(CONVERT(VARCHAR, sjh.run_date),1,4) +...

Be careful trying to rely on NET send as this function is turned off on a lot of client systems by default.  I believe it was with XP Service Pack...

We have a series of DTS packages setup with a Source server and Destination server that go out and gather a lot of information from each of our servers.  Database...

One option would be to create an Instead of Insert trigger on the needed tables.  Inside the trigger you could evaluate the user and check how much data that user has...

BTW... I did go ahead and try XPSMTP from SQLDEV and it appears to be suffering from the same issue for me.  The same servers that are affected for sp_SQLSMTPMail...

Not quite what I was looking for....

We need to continue to support SQL queries as attachments which sp_SQLSMTPMail provides where the SMTP Mail XP does not. 

I am hoping that...

Verify the column type... It should probably be DateTime but the conversion probably set it to SmallDateTime...  This happened to me as well and the data type that it converted...

I experienced the same thing before... If you switch the type to a datetime instead of a smalldatetime, it will probably work.  That is what fixed my issue. 

I had a similar issue in our company... Some plans worked while others failed.... What I found out is that our Network Service department had turned on Disk Quotas that...

Thanks for the Info.. I actually saw a SQLServerCentral article this morning that went along those same lines... It used the /A with dtsrun to assign the values... I like...