Two options:

(1) Do a file existence...

Yes, the same happens for me if I choose those databases. Maybe the Rebuild Index Task doesn't include system tables. Do you have a particular reason for wanting...

Is that the case for the integrity check and the index rebuild tasks? Which databases do you have selected?

John

Here you go.

John

Well, you could do the join in Integration Services. Or maybe Reporting Services has similar functionality as well - I've never tried it. But just because you can...

Find out for yourself:

SELECT compatibility_level

FROM master.sys.databases

WHERE name = 'RicohXenApp'

John

I'm saying that's one way of doing it, yes, but not the way I recommend. If you have access to the definitions of the existing procs and permission to...

Open the task in the maintenance plan and click on the View T-SQL button. Copy the code that is generated and paste it into SSMS. If you run...

Yes, you can get that result with a single stored procedure. If you wanted to use the output of A and B, you'd have to fiddle about with temp...

Please will you post an example of the results of SP A and SP B?

Thanks

John

Well, clearly something isn't right. On the two times it fails, do you have anything in your errorlog? If you're not logging logins in your errorlog then you...

Do you log failed and successful logins in the errorlog of the destination server? If you do, that should give you an idea of why you're not getting the...

Click on the word "this" in my previous post, or copy and paste this into your address bar:

http://www.sqlservercentral.com/stairway/72494/

John

This isn't something that can really be answered in a forum post. Try going through this[/url], and post back if there's anything you don't understand.

John

Those are FOR UPDATE triggers. They will only fire when an UPDATE statement is executed.

John