If you do that I can garantee you another extended vacation right after that one .

Is it used if you query only from its own table?

If so try adding joins one table at the time and see when it stops being used.

Also dates are usually good candidates...

Can I get the ddl to recreate the index?

No need for hints (99.999% of the time).

If you do something like this the index will NOT be used :

where DATEDIFF(D, DateCol, GetDate()) < 15

This version would use an...

Ya try in developpement first.  Once you get it working.  Take backup of production db and run on Production DB.  Take another backup and go take a break

Maybe if we worked on the same data it would be easier.  Here's what I have.  Tell me if it works for you and the problems you encounter, if any...

Copy the system procedure and create under a new name, make the modifications to the copy and use the copy in your code.  That won't break the system and Microsoft...

Most likely because you are logged in as DBO.

That's why I was using fully qualified names in my exemple.  It fails only when no object exists and it should work...

Books online / Unicode / Constants.

By you pretty much need to know what you are searching for in this case .

It converts to unicode.

Ya... that's about the only great thing about 2005.. you can actually see the pairing of those parenthesis so you don't miss any and you don't have to count them...

One step better... all validation with check constraints (just add the case statement to another check constraint / trigger (better error messages) and you're golden) :

CREATE TABLE #Pass (Userid int...

How about this :

DECLARE @pass TABLE (pwd CHAR(8) PRIMARY KEY CLUSTERED)

INSERT INTO @pass (pwd)

SELECT '12345678' --valid??

UNION ALL

SELECT 'abcdefgh' --not valid

UNION ALL

SELECT 'abcdefg1' --not valid

UNION ALL

SELECT '1bcdefgh' --not valid

UNION ALL

SELECT...

update users set password =

(lower(substring(studemo.firstname,1,2)) + lower(substring(studemo.lastname,1,4)) + cast(datepart(day, studemo.birthdate) as varchar (2)))

FROM users

inner join studemo ON users.username = studemo.ident

 I think you'd be better off to start a new thread which specifically answers that question... if not another article altogether!!