having read some rather doom and gloom articles on how the whole cloud paradigm will signal the beginning of the end for databases Im quite pleased everyone seems so negative...

so unless your using any of those there...

thanks for the advice 🙂 went for this (no doubt messy) solution in the end

--------------------------------------------------------------------------------

-- FreeSpace Check

--------------------------------------------------------------------------------

declare @avail int

declare @drive char(1)

declare @dbsize dec(15,0)

declare @logsize dec(15)

declare @bytesperpagedec(15,0)

declare...

no Im old fashioned ... prefer to live in sin !

Wouldn't end the world but...

a wonderful resource thank you ..

however I dont see...

at the end of the day its just yet another contender (albeit not a very strong one) to cause the end of the world ..

there should be a top five...

that explains it wonderfully .. thank you

~simon

http://hasthelargehadroncolliderdestroyedtheworldyet.com/

just in case you need to check .. after all it might have ended in one place and not another !

Thanks Chris .. deeply appreciated 🙂

~si

one day I'll wrap my head round the whole dynamic sql /variable scope thing

An attribute should be dependent on the key,

the whole key, and nothing but the key, so help me Codd.

If your normalization references are twisting your mind - ditch...

thanks Jack ..deeply appreciated 🙂

~simon

also I feel my lack of understanding as to what does constitute a consistency errors i,e

CHECKDB found 0 allocation errors and 114 consistency errors in database

Is that a...

Im so confused now !! ok.. the original error unless Im mistaken referred to index problems ? even though it referred to a column that is not covered by an...

sorry my bad ,, ok with indid

ICX_COMPANY 1

PK_COMPANY 2

restored db to test server , dropped and recreated clustered index .. ran checktable .. still getting

Server:...