All three queries returned the wrong answer for me. My birthdate is this month and each returned an age one year older than actual. The third expression is...

Thanks Erich, that worked. Actually, I had to replace the DB_ID function with the literal value of the database id and voila! It works! Thanks again.

Thanks Dave. I agree with your comment on the index tuning wizard. I ran it once; it recommended a clustered index that covered about ten columns on a...

Thanks Paul! It's the compatibility level; this database was created with the compatibility level set at 80, probably because it was "imported" from SQL 2000. The...

Lucky,

Thanks for responding so quickly. It doesn't seem to matter what I do; if the current database is not master, no go. I just closed out SSMS and...

I just wanted to comment on the "shoestring staff to maintain operations and then use consultants for any additional or specialized work" question. I work for an automotive supplier...

I have tried using DTS to convert an AS400 file to an SQL table...  I gave up.  I had the (apparently common) problem of having the DTS package run fine...