Was the Foreign Key added to the Publishing Database or the Subscription Database?

I appreciate your concern about performance between the 2 functions however, In this situation data integrity is far more important than performance as per my original reply!

Ok thanks folks.

The most efficient way that I can think of is to use xp_sendmail at the end of your Inserts & Updates to send an email to you when an Insert...

Any reason why you are using Dynamic SQL to achieve this simple query?

Although the above may work in my mind it would be simpler if you just used the four...

Personally and from experience, I wouldn't worry about perfromance on this issue!

The reason is that a couple of years ago I got bitten very badly by using @@IDENTITY. One of...

The source system is SQL Server 2000.

I haven't got a timestamp Column on any of the teables yet but can do if I need it!

2 Fact Tables and several Dimension tables.

We...

Or you could use xp_sendmail to send the Crystal Report as an attachement!

Sergiy,

You led me to the answer. In the first query, the Temporary Tables have only 1 row per PersonID. That is why I need the DISTINCT in the 2nd query...

If you suspect the Junior DBA, then disable his/her access and then see if the problem persists. If it does persist, then there must be some process that is stopping it.

I have been in this situation twice.

The best thing to do as Jacek0 has suggested is to use the Identity Column. Once you have done that the painful process begins...

Firstly, I will apologise for creating such a thread.

The reason is that after much playing around, all I did was opened the Excel spreadsheet, highlight the first row been...

Ok thanks for your input you guys. From now on I will be using an Alias.

Ok. Sorry about about that!

That works. How come it works with an alias as oppossed to the actual table name?

Have a look at the Remote Query Timeout option. You set this with sp_configure.