Viewing 15 posts - 91 through 105 (of 105 total)
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...
January 2, 2014 at 10:06 am
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...
December 12, 2013 at 8:34 am
Cheers John. Thanks for your time on this. Russell
November 27, 2013 at 9:08 am
Keith! That's what I'm after. Brilliant.
Thanks again all. Russell.
November 27, 2013 at 9:06 am
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...
November 27, 2013 at 9:03 am
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...
November 7, 2013 at 5:08 am
Nice! Thanks for that, works perfectly.
November 5, 2013 at 4:54 am
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...
October 29, 2013 at 11:06 am
Thanks a lot Bob - Didn't release that option was there.
Have a nice weekend!
October 11, 2013 at 9:31 am
Hi there - Thanks for the response.
I found that this was related to my snapshot path not being unc formatted. All sorted now.
Thanks.
February 21, 2013 at 10:23 am
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...
February 13, 2013 at 9:17 am
Thanks for the information, David.
January 24, 2013 at 4:32 am
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...
January 2, 2013 at 3:59 am
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...
December 19, 2012 at 3:33 am
There will always only be one .bak file as a previous process overwrites the previous days .bak file.
The solution works perfectly! Thanks.
December 19, 2012 at 3:30 am
Viewing 15 posts - 91 through 105 (of 105 total)