Hi,

This should work fine if subscribers are at least SQL 2000 SP3. Check http://msdn.microsoft.com/en-us/library/ms143241.aspx for more details. Of course you should test it first 🙂

With all respect, I don't see why bulk insert would cause problem in TRANSACTIONAL REPLICATION. I read Hilary's answer, but still... Can you shed some light on this for me,...

Hi,

Transactional replication works by reading the transaction log, not using triggers, so it shouldn't be a problem.

Luke's suggestions are pretty straightforward 🙂 I handle this kind of issues in the following way: all login attempts are logged into the server errorlog and I get a filtered...

Hi,

Apparently you set up an updatable transactional replication. You should rebuild the replication, stating that it cannot be updated. Until that, remove the write permission of the developers 🙂

Hi,

If I got you correctly, you want to provide the right for role1 to grant some permission to role2. In this case you can use the grant command with the...

Hi,

In SQL 2008, you can audit virtually anything (including reads) iirc. So a simple way is to upgrade - oops, it's an Enterprise feature of course, but you have...

Not (only) to marketing myself, but if you have PowerShell at hand, check http://getmssqldump.codeplex.com in terms of data movement. With this, you can extract the records into insert...

Hi Neil,

Your backup strategy seems straightforward to me, that is, keeping on disk only the last backup files. Only thing you have to consider if you take also differential backups,...

SQL 2003 does run on Linux. I read it in the CV of one of our DBA candidates. And he was self-confident. So I didn't dare to question him... nor...

Hi,

Just another idea: are the subscriptions logging properly? Couldn't that happen that for some reason the agent cleanup job removes the subscriptions?

Hi,

It can't be something with the OS/HW, otherwise your databases would be corrupt and you'd definitely noticed it. So something is on the SQL side. Question: only the jobs disappear...

Hi,

If I were you, I'd consider removing the constraints and then checking if I can figure out what happened. If it turns out to be something "expected", you can instruct...

If this is an already initialized subscription, I suggest you adding -CommitBatchsize and -CommitBatchThreshold with a low value (I had to set them to 1 in a similar situation), this...

If you raise a few of your questions I try to point you to some specific resources. I've been learning transactional replication for two years (and totally lame in merge...