Change your code. I ran the following (UTC difference is -7 where I am), no problems:

declare @cnt int

declare @utc int

select @cnt = 1

while @cnt <...

Curious, why aren't you using DATEDIFF?

select getdate(), getutcdate(), datediff(hh, getutcdate(), getdate());

Mighty broad question, is there anything specific you are trying to determine?

I won't be hanging around The Thread during the day Saturday and Sunday. From the looks of it, I may be freezing up and down the pitch those days...

Does the following ode help you out?

declare @IntDate bigint,

@CharDate varchar(32);

set @IntDate = 20100224184500;

set @CharDate = CAST(@IntDate as varchar(32));

select @IntDate, @CharDate, cast(stuff(stuff(stuff(@CharDate,13,0,':'),11,0,':'),9,0,' ')...

BaldingLoopMan (2/24/2010)

---

I think i may have made some quick judgements about you Lynn and for that i'm sorry. Apparently those u call friends on this site do not feel you...

halifaxdal (2/24/2010)

---

I just talked to AD guys, one of the clue is: How SQL talks to AD to authenticate a valid user? is it possible to manually configure (hardcode it)...

Tom.Thomson (2/24/2010)

---

I'm slightly concerned about the apples and oranges issue: is what you are measuring just generating a cte with the...

BaldingLoopMan (2/24/2010)

---

============================================================================

gsquared:

One of the most fundamental rights any human being has (or has been denied) is the right to choose with whom to associate. If Lynn, or anyone else, chooses...

Tom.Thomson (2/24/2010)

---

I'm slightly concerned about the apples and oranges issue: is what you are measuring just generating a cte with the...

Ditto, glad you were able to resolve your problem. Also glad that you provided feedback on your problem, as this could help others with a similar problem.

Not sure, but looks like it might be a missing or corrupt xprepl.dll file.

If you do post a dmp file, zip it and attach it to a post.

To do a side by side install, SQL Server 2008 will most like need to be a named instance if SQL Server 2000 is installed as the default instance.

reidres (2/24/2010)

---

The N being written to the table allows you to retreive the data in the proper order by including the necessary ORDER BY clause on the query. With out...