This is gold, thank you!

The solution to my problem, years ago, was that the Registry for both machines was jacked up, specifically in the WOW branches, extra keys had been added and by removing...

Just in case someone else is running into this issue. I am running SQL 2005 sp4 and was having DB Mail issues, following this instruction:

" rerun the script "C:\Program...

And why on earth would I want to allow microsoft to update my production SQL Server for me. This sounds like an argument in favor of deleting this.

For what it's worth I just had the same issue when a network switch went bad. After it was resolved the cluster service was a bit flaky, but after...

You want to look into xp_sqlagent_enum_jobs as this is the proc that's nested into sp_help_job, so you can use this to write results directly to a temp table and then...

Thanks to both of you for these responses, both of those sound like very real potential solutions to the issue. If I go with C# I can hand it...

I once started a job for ICB Consulting in Denver and was told on Monday (my first day) that I was heading to Houston on Wednesday to do some Crystal...

Yeah, why would you say it can't be done when clearly it can.  If you read the file created while saving the .bas file you'll see.....

'---------------------------------------------------------------------------

' Save or execute package

'---------------------------------------------------------------------------

goPackage.SaveToSQLServer...

See this article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;269074

I had this problem a little while ago, bottom line is that if the Job is running under the permissions of someone with Admin permissions then the job...

I am having a similat issue on some of our servers here and the workaround is to put in a registry key, or modify an existing one.  Not sure if...

Yeah, running through all the differences is not a bad idea, there are some differences between servers, Win2k Server vs. Win2003 Server. The problematic setup appears to be Win2003 Server...

Yeah, I have found that creating an alias is a solution, but it's something that I did not have to do for the majority of SQL Servers and I'm wondering...

A little more info on the problem, when I specify the port along with the server/instancename it works properly.

So munson\sql3 does not work, but munson\sql3, 3651 does work.

So it would...

Take your SQL string and set that as the recordsource.  So something like:

dim strSQL as string

strSQl = "SELECT     CentreID, CentreName, CentreNo, CentreAdd1, CentreAdd2, CentreTown, CentreCounty, CentrePCode1, CentrePCode2

FROM         dbo.Tbl_Centre

WHERE     (CentreTown =...