As the most up-to-date status for an item is likely to be important I would enclose this functionality in a view.

CREATE VIEW LastItemDetail

AS

SELECT ItemID,StatusDate,StatusDetail

FROM TableB AS B

INNER JOIN (

SELECT...

If its Adventureworks that you are replicating to 2000 I would check to see if the SQL2005 schema's are the issue.

Failing that, run the sp_MSins stored procedure at your subscriber...

The thing that worries me with Linked Servers is the security aspect.

Our SQL2000 boxes won't delegate but our SQL2005 boxes work just fine.

We have trawled through just about every obscure...

I've come across...

Michael Earl (3/6/2008)

---

Nice article.

I want to comment on your removal of the guts of the delete stored procedures by telling you to look up "Deferred updates".

If you update a column...

What data in your shopper table actually gets used frequently?

A one-to-one relationship is not necessarily a bad thing so if you put your main data in one table and the...

In a similar vein I have solutions architect that has come up with a 5 layer architecture

1. Data Access Layer

2. Entity Layer

3. Business Logic Layer

4. Binding Layer

5. Presentation Layer

I don't...

Restarting the publisher is not a problem.

Restarting the distributor or subscriber may have an affect depending on how long they are down for.

If they are down for longer than you...

I don't know about it being the "only" way but it is certainly what I use.

I have a reporting server and data is constantly being replicated down to it. ...

Yes, that's the one but it doesn't seem to be present in SQL2005 or VS2005.

I would set up transactional replication to server B syncing every 5 minutes. That way you are not going to get sudden huge spikes in traffic just a series...

I try to avoid string manipulation where possible/practical as it computers work better with numbers. Sometimes string manipulation is a necessary evil.

I worked on a project using VS for database professionals and was initially very impressed. I say inititially because I found that deploying the project to an existing database...

You have FLOOR which rounds down and CEILING which rounds up but it doesn't specify decimal places.

You could do something like

FLOOR(Value *100)/100

Depending on what you are doing with your rounded...

Steve,

Your previous feedback is something useful that I can do something with. The situation I am in is that I am trying to move towards agile development but I'm...