Viewing 15 posts - 616 through 630 (of 1,790 total)
Roy Ernest (5/12/2009)
I think the OP wants to do it as part of the Script.
Thanks Roy.
The following procedure will stop the replication jobs for a subscriber. You have to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 8:05 am
Yeah, I have a report that looks at last day of a database backup to avoid things like that. Hopefully you won't have to use the backup. Regardless, have them...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 7:56 am
Just a thought too, but while the DBCC continues you might want to start looking at backups and ensuring that you have one available and ready to go if the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 7:51 am
You should be able to disable them via the jobs. Can you explain what problem you had doing it that way?
Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 7:43 am
Check out THIS LINK and see if it helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 6:18 am
Hey Paul,
I haven't personally made the move that you are discussing but have moved into management and then back out of because I liked the technical. The one thing...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 11, 2009 at 10:58 am
I had used Audit DB from Lumigent a few years ago and it was a nice consolidated application at the time.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 8, 2009 at 10:30 am
Found that the script only works if the fileid's are actually sequential. I have modified this so it works with the following code.
IF EXISTS
(SELECT name FROM sys.sysobjects WHERE...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 7, 2009 at 2:45 pm
Noeld's suggestion is appropriate here. Use a cursor. Refer to BOL for examples. HTH
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 7, 2009 at 12:03 pm
Florian Reischl (5/6/2009)
Alvin Ramard (5/6/2009)
I haven't analyze any data to validate my answer, but I feel that the answer to the original question: "Are the posted questions getting worse?" is:YES!
......
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 6, 2009 at 12:38 pm
You might want to try updating the mdac components. You can download the latest HERE.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 9:45 pm
balbirsinghsodhi (5/5/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 3:20 pm
Nope, should be just one unless you execute one specifically 🙂 . The checkpoint should occur pretty quickly as noted in the one perfmon counter earlier discussed. If you run...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 10:07 am
ichbinraj (5/5/2009)
Approximately how long it will take to complete Online-Reindex process on 1 TB entire database. just rough figure...
-ichbinraj
Too hard to tell. How many indexes are there is the key...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 9:31 am
Standard question / answer but have you rebuilt all indexes associated with this procedure? If not then that should be the first step. The index rebuild will take care of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 8:49 am
Viewing 15 posts - 616 through 630 (of 1,790 total)