Just in case someone else needs help: I had this same problem but was using the Oracle OLE DB Provider "OraOLEDB.Oracle". I resolved the issue by turning "Allow...

Sorry, no. We gave up on it. Regular multi-server jobs using T-SQL propagate just fine, so we'll probably be using those to perform maintenance.

Hi,

I'm having some difficulty with a multi-server maintenance plan. I was able to get multi-server admin configured and the resultant job propogated to the other servers, but when I...

The results were consistent across multiple runs. It had to be some left-over resources or something tied to the original query window. I guess I'll just have to...

Well I copied my SELECT * FROM dbo.VIEWNAME into a different query window and boom, 2.5 minutes. I may have had that query window open for a day or...

Adam, in the bottom portion of your SQL you should be able to replace the entire cursor block with:

EXEC sys.sp_MSforeachtable @command1='TRUNCATE TABLE ?'

Hi Jason,

We are doing a lot of this sort of thing. You can get create statements for views, stored procedures, user-defined functions, and possibly even table triggers--not sure about...

What might it mean if I get negative numbers for the "Unused" column? Would having indexes on a separate filegroup affect these numbers?