Viewing 15 posts - 151 through 165 (of 575 total)
Firstly, this thread should be in the Replication forum.
Secondly, the Subscription expiration value is a property of the Distributor. Have you tried checking the SYstem Tables on the Distribution Database?
January 31, 2006 at 10:31 pm
Was the Foreign Key added to the Publishing Database or the Subscription Database?
January 31, 2006 at 3:58 pm
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!
January 31, 2006 at 3:46 pm
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...
January 30, 2006 at 4:20 pm
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...
January 30, 2006 at 3:58 pm
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...
January 30, 2006 at 3:44 pm
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...
January 30, 2006 at 3:20 pm
Or you could use xp_sendmail to send the Crystal Report as an attachement!
January 26, 2006 at 8:47 pm
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...
January 26, 2006 at 8:46 pm
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.
January 24, 2006 at 10:05 pm
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...
January 19, 2006 at 3:46 pm
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...
January 19, 2006 at 3:33 pm
Ok thanks for your input you guys. From now on I will be using an Alias.
January 18, 2006 at 5:36 pm
Ok. Sorry about about that!
That works. How come it works with an alias as oppossed to the actual table name?
January 17, 2006 at 9:07 pm
Viewing 15 posts - 151 through 165 (of 575 total)