Viewing 15 posts - 511 through 525 (of 1,098 total)
You could create triggers in the tables that you need to audit, and make them send you by email or by net send a message that explains with table what...
June 25, 2003 at 10:38 am
Check first if the log reader manage to move the transactions to the dist db.
You can use sp_browsereplcmds in the dist db to see all the transactions that are waiting...
June 23, 2003 at 1:49 pm
Use:
SET QUERY_GOVERNOR_COST_LIMIT
and check in BOL for more info
June 20, 2003 at 4:10 pm
I suggest you to force the pull of the target servers to the master server. To force the pull means that every target server will connect to the master, and...
June 20, 2003 at 6:53 am
What do you need to check? if the server is up, or the agent running?
June 19, 2003 at 12:27 pm
no you can't use the none parameter with sync_type in anonymous subscriptions.
Anonymous susbcriptions where created for replication over internet, so, usually the subscriber, wich you don't know from what machine...
June 18, 2003 at 4:22 pm
jaja, don't worry guys, here in Argentina I earn 8k only. And it is considered a very good salary. Things are not goin right here, but we do what we...
June 18, 2003 at 10:27 am
Do you mean wich one is faster, or wich is better to use? Can you be more specific?
June 18, 2003 at 10:21 am
Can you post any error that the agents shows in the log, or something more specific of what when wrong?
June 18, 2003 at 10:18 am
Why don't you alter the publication to let the table unchanged. And you delete the tables at the subscriber, manually before applying the snapshot, or create a pre snapshot scripts,...
June 18, 2003 at 7:29 am
You can manually erase the drop table sentence from the snapshot file, and the snapshot will still apply.
Are you running any pre and post snapshot scripts?
June 18, 2003 at 6:37 am
I would suggest you to manually open the .sch files of the snapshot, to see what is SQL changind when applying the snapshot at the subscriber.
You can also check the...
June 18, 2003 at 6:29 am
Run sp_helpserver to see if it is a linked server, if is not, run sp_addlinkedserver, sp_addlinkedsrvlogin and
sp_serveroption with the 'data access' parameter set to true.
Check in bol for all...
June 17, 2003 at 10:18 am
Check sp_addlinkedsrvlogin in BOL. If you use @useSelf = true, then the login that you are using, will try to log into de linked server.
June 17, 2003 at 6:50 am
It would be better to unsubscribe, drop and recreate the publication in the subscriber, instead modifying the sys tables by hand.
June 17, 2003 at 6:33 am
Viewing 15 posts - 511 through 525 (of 1,098 total)