You have set up a SQL 2000 transactional...

Bowling Challenge - The Results

Andy started a contest this summer to see who could develop a T-SQL method of keeping a bowling score. He's finally gotten around to the results after the damage from the hurricanes was cleaned up. See who won and see the code that does the trick.

You have a SQL 2000 transactional publication that...

You have a SQL 2000 transactional publication that...

Which of the following statements are true about...

You create a transactional publication in SQL 2000...

The log reader agent runs until stopped when...

Duplicate Key Inserted Error During Replication

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.

You have a SQL 2000 server that has...

Innovation

Andy has some examples of not very high tech solutions that involve some technology behind the scenes, but the binding factor was that someone had to see the problem first. Not about SQL, but we think it is on topic.