November 29, 2007 at 8:14 am
Hello All:
I am trying to setup snapshot replication on my servers and i am not having much luck. I am pushing the replication. Some of my tables has spaces in the names and I have heard that might be an issue. Any one have any thoughts?
Awake2
November 29, 2007 at 11:16 am
Spaces shouldn't be a problem. What exactly is the problem, are you seeing errors?
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
November 30, 2007 at 3:50 pm
The problem is that I cant push a snapshot replication to the destination. The snapshot part works ok but then it wont push out. All I get it that the push failed because of a "syntax error or access violation." I don't have an error code to go on. I am not sure where to go.
November 30, 2007 at 4:39 pm
Make sure all of latest sql service packs are installed.
Chris Becker bcsdata.net
December 5, 2007 at 1:20 am
Hi,
I assume all the accounts that replication have the proper permissions
Regards
Graeme
December 5, 2007 at 6:33 am
I am working remotely with a co-worker I do not have direct access to the server. As far as I know all accounts have the correct permissions. We are running SQL Server 2000 and I am 90% sure we have the latest service packs installed as well.
December 6, 2007 at 10:59 am
We are running SQL2000 on Windows 2003 server platforms. All versions of SQL2000 have SP3 installed. All accounts have the correct permissions and are accessing the Database daily.
December 6, 2007 at 1:17 pm
Get the latest service pack on SQL2000.
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply