Tracing the nested cursors in that process made my head hurt a little. If you want to stick with a manual stats update process in T-SQL I would recommend you...

Are you following the steps shown in the Workarounds area of the connect itew I linked to above? There are some restrictions depending on how you set it up.

USE [YourDatabase];

SELECT name,

recovery_model_desc,

log_reuse_wait_desc,

is_cdc_enabled

FROM ...

It may work, just realize that you have given up the notion of centralized management. If the restore fails you will not see it in the log on Server A....

I think where jyuan68 is going, and I agree with checking it out, is that if the login used by the Linked Server on the remote server has execute permissions...

osql.exe is not a good tool to use for new development. It has been deprecated since SQL 2005 was released. If you need a command line query tool use sqlcmd.exe.

That...

SELECT [Name] AS [SSIS Name],

...

David92595 (12/21/2012)

---

yes, we are running in comparison to most sql database a rather small and staic database. I was told that a full backup once a day was...

Would like to know the version of the instance but one other beginning question, have you tried selecting the XML out of msdb.dbo.sysssispackages to see if the XML content has...

Are you from the future? SQL 2008 R2 SP4? Just want to level the set before we dig in.

If your logs grew once, after shrinking them they will likely want to regrow again to the same size due to the normal workload on the server. Adding more disk...

"Enabled" = (Not Disabled) 🙂 , i.e. service start type = Manual or Automatic. I like Automatic so I do not need to remember to start it each time after...

Maybe I am confused...why would you ever be working directly with a job_id to call a job remotely? I would not bother with an extra function or round trip to...

Enable and start that service first. Then try connecting to MAINPC\SqlExpress using SSMS 2012.

That still does not resolve the issue of someone having a job_id parked in some code somewhere and that job_id ceasing to exist when a job is dropped and recreated....