This is interesting!

I must surely try this. Thanx for the tip!

Haha. I wish I had did a search before I started on the trek of finding a solution

Thanx

Speed is not a one way measure. Remember that not all things that are slower then others are inherently bad.

You did not mention how big percentage of the total number of table rows are affected by your UPDATE statement?

I assume here that you want to update all (100%)...

And just to point out some details. If you do not care for the ordering of the data amongst the two tables you do not need to add (or use)...

Okay. Finally. Overflow = 17575999 + 1

And this is the working trigger:

CREATE TRIGGER i_customidentity

ON tbl_custom_identity

FOR INSERT

AS

UPDATE tbl_custom_identity

SET Custom_Key =

CHAR (ASCII ('A') + (Increment - Increment %...

Edit: This solution does not work either...

Okay. Try the below trigger instead. It should work in all cases (except for all the cases when the algorith overflows). You can either...

The algorithm you found seems even worse after the second glance. If you substitute 999 as 'Increment' you get: BgK109 which does not seem at all correct.

Do have a look at this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;311231&sd=tech

Especially:

Outlook 2000 works with either an Exchange server or an Internet mail server. You must have Outlook 2000 installed with the Corporate or Workgroup...

Yes. That is because your Outlook is using Exchange

If you do not have exchange, sql mail does not work in SQL Server 2000.

You can use this SP (just with SMTP servers) which was priorly posted here (should still...

Hello.

If you are still here maybe this can help you:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/joining_heterogeneous_data.asp

//Hanslindgren

If the DB is going to be just one (only working with enormous data warehouses), I usually set the file size to the available disc space at once. That way...

I would just point out that ICSharpCode.SharpZipLib, as of writing time, has a nasty drawback; ICSharpCode.SharpZipLib  does not support any files greater then 4GB.

Hi Stephen!

Thank you, it is not always you get such an exhausting feedback of how things turn out when you post replies and hope you can help.

Hanslindgren