We had a problem like that too.  Solution was to have MS come on-site and get them fixed.  They had to try several different things to fix this.

Upside: 

1. Working on...

Posted reply against below link:  (Same topic)

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=124847

The problem I think is that even though you have 2 different nodes the following is happening (I think):

Assumptions:

You are referencing the cluster name for failover purposes

Issue:

The Cluster level places...

CHAR(6) will give you 'ABC___' where _ equals a space

VARCHAR(6) will give you 'ABC' without spaces

Sounds like a bug in Adobe 5 not SQL.  If the same PDF shows correct/incorrect in the different versions of Adobe then there is where the problem is???

As long as you can connect to them via linked server I really don't see why it would matter where they live as long as they can talk....

Dee,

Please see one of the below forums (just replace 114544 with another #)

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=114544

103859, 102346, 113356, 19507, 110085, 119137, 117948, 114609, 119977, 125388, 110622, 108110, 105520

Found all these different...

Why not create Linked server names that you can re-create in your production environment.  You can have multi. linked servers different names linked to the same database/server.

This way when you...

Sounds like the problem isn't with the ALTER statement but with Access. 

I have to assume that you linked the tables into Access and have already ran the ALTER statement against...

SELECT * FROM sysfiles.  This will provide the overall size of the database not what is really used

Paul,

When you set-up the instances on your local machine did you set-up using SQL authentication or Windows?

How are you trying to connect to your local?  If you are attempting...

Try looking in the Master database through either EM or the object browser in the extended procedures section.  This procedure should be there.

You may be having 1 or both of...

Could mean several different things.

1. The BCP format file is missing
2. The BCP format file is corrupt
3. The command calling the BCP is mis-typed
4. The user attempting to run the BCP doesn't have permission...

Unfortunately, that is information you lose when you "upsize" the Access information to SQL.  The structure of Access and SQL for PK and NULL don't talk to each other as...

John,

I can't resist showing people my daughter

With that said... THANK GOD she looks like mommy and NOT me