did you make any more progress on this?

I'd love to hear if you added clustered indexes and if they made a difference.

does this return any results fromt...

check your procedure that is supposed to be sending stuff;

if it has some sort of condition, and the condition is not met, the mail code might not be called at...

it's not easy, and it still requires an identity() column to do it;

I answered a similar post recently here:

http://www.sqlservercentral.com/Forums/Topic1162428-1292-1.aspx#bm1162458

check out that post and see if the example there is what...

I think the only way to handle historical data with DST is with a TallyCalendar Table, where you join dates against the it to get the Daylight Savingstime Offset.

In the...

also the index on [Repl_AxWalton].[WF].[WFInventoryAllocation]: the statsitics on it made it scan a lot more rows: it was estimated @ 215,560 but it actually scanned 431,012,220 rows.

i'd rebuild the index...

i see lots of issues; many , many of your tables are HEAPs, meaning without a primary key and a nice clustered index to access them, they will slow things...

yeah i should have thought like you did about end-user timezone isntead of server timezone.

i did a bit of research, and there's a lot of places that are on half...

you'll want to give VIEW DEFINITION to them;

--at the database / schema level

Grant View Definition ON SCHEMA::[dbo] To [AlmostOwners]

--at the database level

Grant View Definition To [AlmostOwners]

--at the Login level in...

i think you can find it by getting a datediff in hours (or minutes, as some time zones are different by half hours)

and then add that diff to your utc...

there is a project on codeplex i briefcased that allows you to add a CDC equivilent to plain old SQL 2005/2008, stadnard editions , so you don't need Enterprise...

you can use the LEN() or DATALENGTH() functions:

SELECT max(DATALENGTH(TheTextField)) As MaxDataLength FROM

TheTable

by max character you mean the highest ASCII value? like 'A' = 65 and 'a' =97?

so the highest "char" in 'bananas' is 's' with an...

tough to diagnose without the whole, testable code...

there's a table variable that's missing, and the declaration and assignment of the @Counter is missing...it does get assigned the value of...

pretty interesting; for one specific collation, i ran this query and got a lot of interesting results...A=À with an accent, for exmaple. I'd seen this before, good to be aware...