Viewing 7 posts - 1 through 7 (of 7 total)
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...
March 7, 2008 at 11:10 am
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.
January 30, 2008 at 10:34 am
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...
January 29, 2008 at 12:10 pm
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...
January 28, 2008 at 6:13 am
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...
January 25, 2008 at 1:06 pm
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...
January 23, 2008 at 6:43 am
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...
September 15, 2005 at 5:50 am
Viewing 7 posts - 1 through 7 (of 7 total)