Why not create one job with all the steps calling next job on success and just run this one job from the command prompt.

See =http://www.sqlserverspecialists.co.uk/blog/_archives/2009/5/5/4175469.html

You may have the same issue.

Sorry for the delayed response, you can use SQL 2008 central management server to manage SQL 2005 servers.

I usually run jobs using the SA account, and ensure that this service account has permissions on all the folders and is also an account that has permissions to send...

Once upgraded to 2008 you cannot go back so if you have to failover to DR you will be on SQL 2008. If you have tested that you application works...

Why not use Central Management Servers with the SQL 2008 Management Studio and look into using Policy Based Management.

Should read Insert into #temp (MyID, MyName) as you have listed...

Like you I have seen a demo of PowerPivot and was impressed by what it can do, but I find it a little scary. Its very easy to design a...

We had a problem with setting the collation when building a SQL 2008 cluster, the solution for us was to slipstream service pack 1 into the installation file and then...

SSIS is not cluster aware so in a clustered environment, you are better storing the package in msdb, as the file system from the 1st node might not be seen...

Users only need to be members of the fixed role db_backupoperator to be able to take backups, they do not need to be system administrators, as mentioned by Sqlfrenzy.

Add an expression to the color field.

Example:-

=iif(Dataset!field.Value<2,"Red","Black")

Why not just do a query or Stored Proc that pulls out the records you want and just schedule another email from reporting services to send to the email addresses...

See http://msdn.microsoft.com/en-us/library/ms141209.aspx you will need to use the 32 bit drivers. Not nice, but there you have it.

You could try adding an alias to the server in SQL Server configuration manager, that sometimes works. Another thing that I've seen work is to have an actual mapping to...