Viewing 15 posts - 841 through 855 (of 1,790 total)
Ok. Thanks for the update. I do know that you can typically clean up the old replication stuff but it can be a bit persnickety if it gets in an...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 8:12 am
From BOL:
Understanding DBCC Error Messages
After the DBCC CHECKDB command finishes, a message is written to the SQL Server error log. If the DBCC command successfully executes, the message indicates...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 10:01 pm
I'm pretty sure that executing the following will take care of your situation. However, having not been in it I can't say for sure. 😀
The following are steps 6 and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 9:51 pm
You seem to be on the right track and merge replication would certainly cover what you are trying to do. You might also look at peer-to-peer transactional replication but you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 8:19 pm
Just a quick update but I did do some testing and found that there is additional cost associated with the use of these as expected. Some of it is a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 3:49 pm
Grant Fritchey (2/3/2009)
And apparently I'm no longer able to work the link buttony thing... If only it were a fiber optic laser beam assembler... I'd be fine.
I always have to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 2:56 pm
Bruce W Cassidy (2/3/2009)
DavidB (2/3/2009)
With that being said though do you have any experience with instead of triggers and if so, what...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 2:05 pm
Jack Corbett (2/3/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 1:49 pm
Bruce W Cassidy (2/3/2009)
You might consider "database architecture" to be the parent of "database design". The architecture you choose will (to some degree) dictate how...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 1:35 pm
Thanks Jack! I will check out the discussion. I had just read the article prior to posting. Great article by the way.
Need is a big word that most people...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 1:33 pm
GilaMonster (2/3/2009)
ex__inferis (2/3/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 1:18 pm
I think he meant http://www.sqlservercentral.com/Forums/Topic642190-145-1.aspx#bm648464
Thanks for the laugh Grant... 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 1:12 pm
NotManyPoints (2/3/2009)
It was a quizzical comment on the information about a person possibly...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 3, 2009 at 8:49 am
Just a note, but just because AWE is enabled and you have 26 Gig allocated doesn't mean that you are covered completely from the memory needs of an instance. There...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 2, 2009 at 1:02 pm
Yes, Lynn is correct. No need for the trace flag.
Do you have any errors in the SQL Server Error Log or the Windows application log?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 2, 2009 at 12:39 pm
Viewing 15 posts - 841 through 855 (of 1,790 total)