ive had this a few times and never got a sucessfull explanation for it ...

it normally happens to me if i'm running an xp in 2000 (such as xp_cmdshell) if...

i would suggest you start using the ANSI-92 SQL syntax it makes debugging duplicates much easier

i rewrote for you....

also - is it possible you are seeing duplicates in RS because...

i just ran the following

select AVG(convert(float,id)) from sysobjects

seems to work fine for me

are you sure didn't type in

select AVERAGE(salary) from #table - that would explain the error

another perspective on this - your primary keys and foreign keys are the same - this doesn't sit well with me

my version of the students table would be (i'm assuming...

in that case it all edpends on how big and how volatile your data is.

the bulk of the memory will be used for buffer cache, but...

you can always use the sp_oa proc calls to asyncronously execute stored procs

that way you don't have to use service broker

here is some sample code i provided to some of...

32 or 64 bit ?

AIRWALKER-375999 (4/26/2012)

---

Thank you all for you're assistance, I think I'll need to redesign the query as what I want do I dont think is possible within a case statement, I...

i think what you are trying to do is either an inner join or some kind of where clause ?

e.g.

select name from users where id='1234567890'

rather than

select case when userid='1234567890'...

all looks ok to me - mostly

here's a test for you to perform (i have a suspicion i know what the problem is)

open up management studio and open 4 query...

i have no idea what the difference is between...

On one of the three server pairs in question, yes the hotfixes don't match (2282+2187, and I am awaiting clearance to patch)...and of the four times we have had this...

ps - it was fixed in a service pack version - but since it's sql2000 which i haven't used for 6 years i have no idea which one

GilaMonster (4/25/2012)

---

How can you do an index defrag of a log shipping secondary? It's read-only at best. Or do you mean index rebuild on the primary and log shipping copied...

index defrag