Viewing 15 posts - 781 through 795 (of 1,790 total)
Very glad that worked for you and thanks for following up on the post!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 1:28 pm
Yes.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 12:26 pm
Seems to be a permissions problem. You can run the following to validate that it has nothing to do with the restore;
RESTORE FILELISTONLY
FROM DISK = N'\\prod_server_name\drive$\sqldumps\prod_db_name.BAK'
If you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 11:38 am
I'm sure someone can come up with something better but for those articles that are critical for us we log the datetime that they were inserted into the publishing database....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 11:19 am
You can use tracer tokens for some of this analysis but I'm not sure that will provide you with exactly what you were looking for.
This script is from Hilary...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 9:11 am
Phil Factor (2/10/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 8:39 am
This post from Buck Woody explains the report and there is a link on there that refers to the fact that this is part of the plan cache. You will...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 6:48 am
It should still only be the one publication on DB1 (primary server) with subscriptions for DB2 (primary server) and DB1 on secondary server. Should work fine.
Glad that NoelD was able...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 7:23 pm
I'm with Grant, if the right opportunity came up then why not (not me, I couldn't ask for a better place and wouldn't consider looking....).
You do have to be careful...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 4:03 pm
Dr John Stott
"Nearly all legislation has grown up because we simply cannot be trusted to settle our disputes with justice and without self-interest. A promise is not enough; we need...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 1:38 pm
If you are really doing a rebuild then you can use the STATS_DATE function to get that information. Other than that, there is no definitive way to get the information...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 1:21 pm
Ok, understand now. Yes, we do that now, or some variation of that. I was going off the OP question about having to drop the tables as being a requirement....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 12:36 pm
noeld (2/9/2009)
There are many solutions that can...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 12:24 pm
Ratheesh.K.Nair (2/9/2009)
I have run some update statistics and index reorganize commands but they are not shown in SQL Server logs.
Have you seen somewhere that these are logged events? I don't...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 8:30 am
I'm going to try to play with this later today to see what shows up in profiler and I will post back the results (unless one of you fine gentlemen...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2009 at 7:07 am
Viewing 15 posts - 781 through 795 (of 1,790 total)