Viewing 15 posts - 211 through 225 (of 1,098 total)
When you update data at the subscriber, SQL begins a distributed transaction and apply that change in the subscriber and also in the publisher. If one of them fail, then...
March 29, 2004 at 5:34 am
Try specifying the alert for error 170 instead of severity.
March 26, 2004 at 2:24 pm
Does you process access both remote and local server? If not you could create a job in the remote server to execute the query.
Do you execute the process from an...
March 26, 2004 at 2:01 pm
Strange.
Run sp_helpmergearticle and check if there is any configuration difference between those problematic articles and the rest.
March 26, 2004 at 1:50 pm
Once I create tables to save the configuration of my replication, and also create script to create the replication stored procedure with the information on those tables.
Seems complicated at the...
March 26, 2004 at 12:56 pm
Did you change the server name while replication was setted up?
March 26, 2004 at 12:54 pm
I think SQL create merge stored procedures with each reinitialization you made to the publication. Basically, every time you create a new snapshot.
Merge replication uses mucho more stored procedures that...
March 26, 2004 at 12:53 pm
Check if the user in the db is member of another role that deny access to any object and check the permissions in the public role, wich of course that...
March 26, 2004 at 12:36 pm
I think not. Only the table owner or db owner.
In the other hand, you could create a stored procedure wich creates an index and then you grant execute permission on...
March 26, 2004 at 11:42 am
If it is a job process you can try stopping the SQL Agent. If not I think you will have to restart the sql server.
If after rebooting, the process connect...
March 26, 2004 at 11:37 am
The msx server name refers to the Master server, not a target.
Do you have configured a master server?
Do you have the master and possible target server registered in EM with...
March 26, 2004 at 10:36 am
It is possible that it is an issue of EM. However I would check the SQL Log of that server to be sure.
Sometimes it is necesary to close and opened EM,...
March 26, 2004 at 8:40 am
Thank guys. My first posted question.
I actually have 90 TSX Servers. And I setted up the polling interval to its maximum in all my servers. Wich is 28800 seconds (8...
March 26, 2004 at 8:06 am
Viewing 15 posts - 211 through 225 (of 1,098 total)