Viewing 15 posts - 1 through 15 (of 534 total)
Thanks anyway but the Default Trace does not go back far enough.
January 29, 2019 at 7:33 am
THank you. Found it in Configuration tools and enabled it
April 10, 2017 at 3:00 am
sorry again.....
I am at the point where I am adding the Subscription - I am using what was generated when I scripted out the Publication before I...
April 7, 2017 at 10:39 am
That did not work. Not sure how to go about disabling and then recreating the Publication and Subscription. simply delete and recreate?
April 6, 2017 at 1:42 pm
currently I have the log reader stopped because of the errors it is generating. so I should start the log reader and then re-initialize the subscription?
April 6, 2017 at 11:09 am
I have the following:
REPL - History Cleanup
REPL - Distribution Cleanup
REPL - Subscription Cleanup
REPL - Log reader <---------- only one
REPL _ Snapshot
REPL _ Distribution...
April 6, 2017 at 10:46 am
Still encountering problems.
We managed to get our Distribution Database recreated using the Configure Distribution Wizard in SQL Server...
April 6, 2017 at 9:40 am
Running 2008R2 SP3 (64bit) with an 8GB memory max. Available Memory on Server 40GB
September 21, 2016 at 8:52 am
Thanks, someone provided this and it did the trick
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
-- CREATING A TEMP TABLE TO LOAD...
August 7, 2015 at 7:14 am
After doing a packet level trace, we found that the only IPs used when replicating from a Cluster to a standalone SQL Server were the IPS address(es) of the Nodes...
June 29, 2015 at 7:53 am
duly noted about the autoshrink being a bad practice. Thank you!
May 4, 2015 at 9:05 am
What I am running into now is this error when attempting to grant Alter when the user is the schema owner:
GRANT ALTER ON OBJECT::schema.tablename TO username;
GO
Cannot grant, deny, or...
March 18, 2015 at 11:04 am
Viewing 15 posts - 1 through 15 (of 534 total)