so resetting the server should be a simple way to fix this!?hopefully

i am positive. i have 3 test servers(real old decommisioned servers), and my own pc, which is a pentium 4, 32bit processor. i am positive all of the computers have...

dont get me wrong, im not trying to cheap out on the book, i just wanted to know was it worth it, or could i easily learn enough without the...

did you delete the login from the whole server , or just from each individual database?

books online will help you with anything you need, and this site when you get stuck. if you know basic sql, then your half way there. im no genius, but...

sorry, here it is:

select

top 5 f.film_ID,f.film_Title, sum(

thanks for that, it helped me greatly. much appriciated

sorted it, was a silly question. sorry for taking up your time.

thanks for the help guys. i opened up "edit table" and on each column i  checked for a unique field, but could only find one on the primary key. when...

USE

[SRDB]

GO

/****** Object: Table [dbo].[MCSFinFactData] Script Date: 11/06/2006 14:46:47 ******/

SET

ANSI_NULLS ON

GO

SET

QUOTED_IDENTIFIER ON

think you have hit the nail on the head. we do use active directory. it is , for lack of a better term, dodgy at times. il investigate this avenue...

its not supposed to be anything except windows auth. it worked like that on the old server, the new server is set up for windows auth, yet it does not...

here it is again.

no , only varchar columns. it runs fine on database A on server A, but database b, which is identical to database A, it wont run on ( database b...

but from day one there has always been up to 50 programId's in the table, since 1997!. i agree with you , that the update is wrong, but why did...