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

So there are other triggers on the table? Please will you post the definitions for them?

John

Have a look at this page. Your trigger is INSTEAD OF UPDATE, but you're doing an INSERT.

John

When you use xp_cmdshell, the command runs in the context of the SQL Server service account. There are two things you could try: make sure that the folder that...

Do what I did and type "cluster command line" into your favourite search engine.

Or just guess - the command line utility is actually called "cluster". But you'll still need...