Why are you doing two validations against CUR_STAGE?

You have already validated that they are 'IN' those particular definitions.

I would get rid of the WHERE clause.

Do you not want the character that you listed on the left of your sample?

I would assume that it is exporting "column","column","column"...

If that is the case where your unwanted character...

Tim,

It was my understanding that the /3GB parm in the boot.ini was only needed for windows XP. If you are running your SQL Servers on Server 2003 or greater...

If the above suggestions dont work for you there are other methods listed by Microsoft. Each of these methods do require DT.

http://support.microsoft.com/default.aspx/kb/307487

Have you tried...

PASSWORD = { password | @password_variable }

instead of

MEDIAPASSWORD = { mediapassword | @mediapassword_variable }

It may be a long shot but I am sure it wouldnt hurt...

http://support.microsoft.com/kb/934749

Before you install the service pack and hotfixes, pause the other nodes. To do this, follow these steps:

1. Fail over to the new node.

2. Pause other nodes.

3. Install the SQL...

Can you uninstall the default instance and leave the remaining named instances intact?

Microsoft also recommends that you have applied service pack 4 to your SQL 2000 instances before installing SQL 2005 on the same cluster.

This would also need to be done if...

If the failover cluster is working properly a simple refresh of the end-users screen should be enough to establish a new database connection.

Since the end-users connection should be setup looking...

-- Login: xxx

CREATE LOGIN [xxx] WITH PASSWORD = xxx HASHED, SID = xxx, DEFAULT_DATABASE = [xxx], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

Edited with the 'xxx' for security.

The T-SQL that was generated by the sp_help_revlogin all the users had the following code:

CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

and after doing a couple of searches I found that the...

It was a 2005 to 2005 transfer and yes they have the same sort order.

The errors were 'log in failed please see your system administrator', changing their passwords worked and...

FYI...

First morning into production, none of the user passwords passed through. For the lack of a better word the pw's were corrupt. We had to have all our...

That will work great for me thank you very much for the link.

Here is a really good thread on the topic.

http://www.sqlservercentral.com/Forums/Topic558227-146-1.aspx