Hi there,

In terms of the database instances, I have installed SQL 5 times on the same server. This might not be called a database instance but I have...

Thanks Chaps.

Yes, Kurt. This is to manage multiple databases, where majority of the time I don't know what the database names are that are being restored. As the...

Cheers John. Thanks for your time on this. Russell

Keith! That's what I'm after. Brilliant.

Thanks again all. Russell.

Thanks John - This is the issue. I created a default instance for SQL2012 and a named instance for SQL2008. Whenever I connect to my (local) instance it...

Thanks for your response Sean. Your example code works perfectly.

I was trying to get around the fact of using a temp table but if that's the only...

Nice! Thanks for that, works perfectly.

Found this out whilst testing.

SQL will gracefully failover if the version of SQL you are failing over to is the most recent version (i.e. you can’t failover to a retrospective...

Thanks a lot Bob - Didn't release that option was there.

Have a nice weekend!

Hi there - Thanks for the response.

I found that this was related to my snapshot path not being unc formatted. All sorted now.

Thanks.

Thanks for your response.

However, I am using the same account that the servers run under for the merge agent. I have tried creating a new user for...

Thanks for the information, David.

Hi Ben - I think you're after the following;

SELECT [cx].[refcounts]

, [cx].[usecounts]

, [cx].[objtype]

, [st].[dbid]

, [st].[objectid]

, [st].[text]

, [qp].[query_plan]

FROM sys.dm_exec_cached_plans cx

CROSS APPLY sys.dm_exec_sql_text( cp.plan_handle ) st

CROSS APPLY sys.dm_exec_query_plan( cp.plan_handle ) qp

The...

Thanks for all your responses.

I will use the solution Steve posted as this works.

Steve - there will always only be one .bak file in this folder...

There will always only be one .bak file as a previous process overwrites the previous days .bak file.

The solution works perfectly! Thanks.