Something like this?

select * from sys..dm_exec_cached_plans

WHERE objtype = COALESCE(@obj_type,objtype)

John

It doesn't make a difference whether you have active/active or active/passive. You still need one for each node, one for the cluster, and one for each SQL Server instance,...

I've just run a test. I created a new share on my PC and then backed up a database from a server to that share. No problem.

I suspect...

Joice

I'm afraid I don't have much experience of using the Lookup transformation. I've tried everything that was obvious - hopefully somebody else will be able to help you.

John

That's the point I was trying to make, Joice - that SSIS and...

If you use your favourite internet search engine to look for that error message, high up on the list should be a Microsoft support page that gives lots of information...

Joice

I don't know what the problem is, then. The only thing I can think of is to set something up that writes the values of the parameters to a...

Joice

Do you know what values are being passed to the CHARINDEX expressions? If they're numbers in character format, they might be getting interpreted as integers when the database engine...

Let us know how you get on, Brandie. You can make the toolbox auto hide again once it is docked where you want it.

John

Brandie

Floating might be unavailable because the toolbos is Auto Hide. If you turn that off, you should be able to drag the toolbox and dock it at the bottom...

You could try logging the output of your job to a table instead of to a file. Then you can query the table, remove rows that you don't need,...

As I said, I've never tried it myself, so it's up to you to experiment. Start with the events in the Security Audit section.

John

In that case, it'll be the database name specified in the connection string passed by the application. You have the IP address of the computer the connection was made...

Try using the PRINT command to see what SQL you will be executing. It might be obvious what the problem is if you do that. In the absence...

Zohreh

You need third-party software to do this. Search for "sql log reader software". It's not cheap!

John