Unfortunatly I ran into exactly the same problem. The answer is that there is no way to tell SQL 2005 to be non-case sensative when it comes to passwords.

My...

See now I just use my already completed time machine to check on the answers for my SQL questions.

I mean time travel is easy .. just make a promise to...

Here is a different option that doesn't require using upper. I only mention it because I think its really cool 🙂

SELECT SUBSTRING( Account, 1, 10 ) collate SQL_Latin1_General_CP437_CI_AS AS...

Another option is to use a NOT EXISTS.

SELECT * FROM Master M

WHERE NOT EXISTS (SELECT 1 FROM StartDate S

...

Another option (one I'm using) is to store your data in a table on each server. Then write an SSIS package to collect (and possibly condense) the data onto...

If you are trying to profile (which sounds like the best option from what you described above) any time a tables data is changed your best bet is going to...

Unfortunatly this is for our development machines and with a mixed environment (mid upgrade) we need them to have both sets of tools (and to be honest there are just...

What data type is the column?

If its a char or varchar you could do the following

Charindex('.',REVERSE(@test))-1> 7

I was trying to figure out how to handle it if its a decimal...

I've done plenty of versioning in databases before and generally we used Extended properties to mark which DB was which. That probably won't work for you given that you...

I had a simlar problem one time where we were doing a migration on an OLTP database. The DB was only 20 gig but my transaction log balloned out...

I don't know what to tell you. My server/databases are set with collation SQL_Latin1_General_CP1_CI_AS but when I try to log in with my password I can log in with...

Actually it seems in 2000 by default they care case-insensative but can be changed to be case-sensative.

Here is an interesting article on the subject

http://secretgeek.net/sql2k_2k5.asp

Yes. Grants are cumulative. As long as there isn't a DENY somewhere he should be able to INSERT, UPDATE, DELETE and SELECT

No.

The deny will override the grant.

I could be wrong but I belive that is the case. Every server I've looked at (more than 20 over 2000 and 2005) has those values for the system...