When E0A001 incremenst to E0Z999, what comes next:

E1A001?

Does that go to EZZ999? The rules for creating the Aplha part don't seem very clear to me.

I'd agree with...

A good overview of System-R:

http://www.cs.berkeley.edu/~brewer/cs262/SystemR.pdf

As to how the System-R design principal rippled through to Oracle and Sybase ( and later SQL Server), I'm afraid I don't have much insight. ...

Just for ease of use and potentially quicker response, I tend to script out things like logins, database users, procs, triggers, and views that I might need to restore quickly....

There are some excellent string splitter functions you can search for on this site (Jeff Moden's is the one most recommended for speed and flexibility). Any of these would...

Converting a date back to a date will end up displaying the date in the same default format.

Try:

Convert(varchar(20),Date_Start,103)

From the MS site:

A common table expression can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE,...

Hmmmmm... Based on what I saw of the article, I'd have to say that the conclusions drawn were unwarranted. I didn't see anywhere where the 3 different queries...

And if your database is used by more than 1 application? Having all the data manipulation in stored procedures means that multiple applications can use those procs without having...

The datetime datatype holds date data in an internal format that doesn't look like a date. I'd don't remember the exact format, but for purposes of illustration, pretend that...

The internal datetime format is irrelevant to the display format. Both those datetime columns will have the same internal format regardless of which format you use to insert the...

Just have to rule out the obvious: Are you sure you ran those queries on different instances? What does @@servername say?

There is an excellent article on the SQLServerCentral home page today on that very subject:

http://www.sqlservercentral.com/articles/delete/96780/

Be sure to read the discussion on the article, since it has some alternative methods and...

What database are you trying to open in the login? I've seen this when the database specified in an ODBC connection doesn't exist on the server or when the...

I'm glad it got resolved. Because those passwords don't travel in clear text anywhere that I know of, you might have to get a sniffer and compare the successful...

You could always change the password to what you think they are using and have them try it again. If it works, you have your answer.