Definitely does matter to me...

If i'm not interested in the work then it's very hard to feel motivated.and I think you need to be motivated and interested in your work...

Hey TravisDBA...

That sounds a little cynical...but I suspect true....

Being a Manager myself I take motivation and reward quite seriously and I don't just give rewards for people turning up for...

Hi,

I totally agree with Steve on this.

Of course there is a need for some form of performance appraisal needed for employees. But this doesn't have to be in the form...

Hi,

I'm from Bexleyheath, Kent UK

Work near Waterloo Station London.

You can drop and reapply FKs while replication is running although I would stop all the agents while you re-apply.

You can drop the FKs and reapply with the NOT For...

Hi,

Without knowing too much about your case..

What about using merge replication making the SQL 2000 machine the publisher and all the other MSDEs as subscribers. That way data can be...

Hi,

Not quite clear about the problem.

How many databases are there ?

How is the replication specifically configured i.e. Merge from A to B Tran from B to C etc ?

Need a...

Hi,

That does seem very long indeed.

Can you provide a bit more info on your problem.

The databases being synch...where are they in relation to each other. Are these 200 tables big...

This error from your original post

Implicit conversion from data type datetime to tinyint is not allowed. Use the CONVERT function to run this query.

(Source: SQL-UK2 (Data source); Error number: 257)

Would...

Hi,

If the restored db is on the same server can't you just replicate the one table from the original db..

Might need a bit of code change as you have mentioned...

Hmmm..that does sound horrible.

Is it only new data (inserts) that is occuring or are there historic changes ?

How big is the database ?

If you needed to reinitailze all subscribers...could you...

Hi,

I'm not quite sure of your set up..

3 servers..all with published data bases...are they all publishing to each other ??

Thanks

Graeme

Hi,

You should have ALTERED the publisher table.

Having added it back to the publication and added the subscribers, you re-run the snapshot and distribution agent and away you go..

Yes sp_repladdcolumn is...

Hey Sourav-657741,

As far as I know the MSREPL_tran_version column has a default on it so it should never affect your insert statements.

What you should be doing is explicitly naming the...

Hi Guys...

This year we have migrated from 2000 to 2008..and I had the joy managing this.

Top of the list is Test, Test, Test.....oh and one other thing....Test

It sounds cliched...