Jeff Moden (9/16/2009)

That's the whole idea behind using the surrogate key instead of a natural key which may be duplicated. The users wouldn't see it but the join to...

What sort of replication are you doing? Snapshot, Transactional or Merge?

Over the years, I have used (but not for DW):-

ErWin - good, but expensive

ER/Studio - my favourite, but again, expensive

Powerbuilder - OK, again expensive

Visio - very slow, especially for large...

The query you posted gives a syntax error... but I see what you are trying to do.

The reason is is returning 2 is because you are looking for the MAX...

Err Umm, yes. Maybe I should keep quiet:-D

No worries... glad you got there in the end.:-)

Damn!

In one of your earlier posts, yoa said

I think I'm going to declare a variable in the stored procedure and assign rowcounts to it. Then I'll push the values into...

As I hinted in my earlier posts, it sounds as though you have different ANSI settings.

In SSMS, right click the server and click properties. On the Connections page, you...

One thing I hope we DON'T see... that shirt of yours:-D

This bit of advice goes for all tables, but I'll illustrate it with this table

CREATE TABLE Operator (

OperatorID CHAR(10) NOT NULL PRIMARY KEY CLUSTERED,

OpsFirstName CHAR(35) NOT NULL,

OpsMiddleName CHAR(2) SPARSE NULL,

OpsLastName...

Yes, you can cluster the distributor... when you fail over, everything should carry on as before.

I had a similar problem on a system years ago that I eventually traced to blocking at the subscriber.

With the distribution profiles left at the default, SQL Server groups...

I'm not sure how to get at @@rowcount in SSIS (don't have an SSI environment available at the moment).

Try putting different SET statements at the top of your procedure and...

A list of the files would have helped to provide a definitive answer to the question. Are they possibly:-

*.SCH - table definition

*.DRI - definition of the indexes and constraints

*.TRG -...

I suspect Paul is pointing you in the right direction, but I would also add a few perfmon counters to rule out the I/O subsystem as the source of your...