Viewing 15 posts - 436 through 450 (of 1,098 total)
Dropping the publication doesn't have to delete any article. can you tell us wich article is that?
September 25, 2003 at 2:32 pm
execute sp_helptrigger tblDelete.
Check the owner of the trigger.
Also check that the trigger is enabled, and you could also add some prints inside the trigger to check if it is running
...
September 25, 2003 at 2:26 pm
to drop a publication, first delete all the subscription...
run sp_helpmergesubscription from the published db. Then drop those subscriptions with sp_dropmergesubscription.
Once all the subscriptions have been deleted, drop the publication with...
September 25, 2003 at 2:18 pm
I don't understand...are you trying to remove the table that was published?
Droping replicacion is just deleting the records in all the system tables referencing that publication or configuration, not its...
September 25, 2003 at 1:42 pm
You might consider placing the distributor on a separate server, or even in the subscriber.
But to minimize workload, you shoudn't create the distributor on the publisher.
September 25, 2003 at 8:47 am
If you want to fix the problem, if you still have the nominal (810046) in the publisher, try inserting that value into the subscriber with the error. If you deleted...
September 25, 2003 at 8:42 am
I've compressed snapshot files into cab files letting the snapshot agent to do it, but also didn't compress the snapshot and then manually compressed all the snapshot files with rar...
September 25, 2003 at 8:31 am
That login is created during creation of the distributor. You should first, reconfigure your distributor and drop and recreate all your publications if any.
September 25, 2003 at 8:22 am
Instead of searching the db, you should check what process in consuming the sql resources, and then if necesary find out from what db that process is connected.
You can run...
September 18, 2003 at 10:19 am
Yes you add Andy's parameters on the second step of the log reader agent job... or you can also run the log reader from the command line with the logread.exe...
September 18, 2003 at 10:12 am
If you have a slow link between the databases, running queries to know the differences can be too slow. So you can export to files the tables that you want...
September 18, 2003 at 9:18 am
You can run profiler to check what is executing in the server or in a specific database.
You should also run sp_who2 to know what proceses are running and with dbcc...
September 18, 2003 at 8:34 am
For me it is always better to use the stored procedures to do anything with replication.
The sp sp_dropMergeSubscription must be run on the publisher DB on the publisher.
If you...
August 25, 2003 at 3:16 pm
Are you using Transactional replication?
It seems like a problem in your db, do you have any option in dbcc to try to fix the db, like REPAIR_REBUILD in 6.5?
August 25, 2003 at 10:17 am
Viewing 15 posts - 436 through 450 (of 1,098 total)