Viewing 15 posts - 1 through 15 (of 19 total)
On replication monitor - Distributor To Subscriber History shows "No
replicated transactions are available." whereas Publisher to distributor keep working fine by showing "Delivering replicated transactions, xact count: x and command...
July 6, 2012 at 12:38 am
pls help on above.
July 3, 2012 at 11:57 pm
Hi,
I also have the same error "No replicated transactions are available" although there are many transaction on distributor to be applied. I have got no error in any of the...
June 29, 2012 at 11:50 pm
Thanks a lot. I have truncated transaction log.
One more thing...Can delete the initial snapshot files as they 60 GB in size and my replication is running from last 20 days...
May 25, 2011 at 1:34 am
Hi,
Thanks for your reply.
There is nothing in the log.
log_reuse_wait_desc showing 'nothing' and DBCC Loginfo is showing 8663 VLF and two oldest VLF having having status 2.
The log size increased during...
May 24, 2011 at 6:43 am
Hi Lowell,
Thanks for your efforts. I got it resolved by enabling "Network Discovery (NB-Name-In)" rule ( UDP port 137) in windows 2008 firewall on the remote machine. You can check...
April 1, 2010 at 2:19 am
Hi Lowell,
Machines are in local network, They are not over the internet and the reason for not using IP is that I am giving remote machine as the distributor and...
March 30, 2010 at 11:08 pm
I checked and found that Client Server can't resolve the remote server name when the firewall is on. I think this is the only problem. What should I do to...
March 30, 2010 at 6:58 am
Hi,
U r right. It may be firewall issue. But what port I should allow for SSMS? I already allowed sql server port. Both the server on LAN and not exposed...
March 30, 2010 at 5:23 am
Hi Florian,
Still waiting for your reply, may be you bit busy but please take some time to make it run on MSSQL 2K.
Thanks
Vivek
November 10, 2009 at 2:08 am
Hi Florian,
Resolve the issue replacing -
DECLARE @select VARCHAR(MAX)
With
DECLARE @select VARCHAR(8000)
&
changing this query
SELECT @object_id = object_id, @schema_id = schema_id
FROM sys.tables
WHERE...
November 7, 2009 at 4:18 am
Hi Florian,
Still getting few errors -
WHERE TABLE_SCHEMA = SCHEMA_NAME(@schema_id)
'SCHEMA_NAME' is not a recognized function name.
DECLARE @select VARCHAR(MAX)
Line 82: Incorrect syntax near 'MAX'.
Please suggest on this.
Thanks,
Vivek
November 7, 2009 at 3:21 am
Hi,
I tried this on SQL Server 2000 but getting error on VARCHAR(MAX) line.
Will it not work on SQL Server 2000?
Thanks,
Vivek
November 6, 2009 at 6:15 am
Viewing 15 posts - 1 through 15 (of 19 total)