Why do you want to transfer this data to Access, particularly as it is on the same server as SQL? 

If you want to use the Access forms and reports...

We had a similar problem where some NT group names were changed, but our standard security setup meant this was not a big problem for us.

We use database roles to...

This is not an easy one to sort out.  One of the problems is that the sid held in sysxlogins is the NT account sid, but the name value is...

The article shows the danger of trying something out with a small set of data, and expecting the same results with a large set of data because of an assumption...

The 'garbage' may be due to the mainframe data being in EBCDIC while Windows works in ASCII.  It is possible to automatically convert from one format to the other.

You will...

My 2p...

1p) Have you given the SQL service account the 'Impersonate client after authentication' right.  The need for this is not in BOL, but is in a KB article.

2p) We...

I recently ran some tests with DBREINDEX, using SQL 200 SP3a Hotfix 928.  I do not know if the results would be different at a different fix level.  I found...

If you are accessing native VSAM, as opposed to VSAM used for IMS or DB2 databases, you need a VSAM ODBC driver installed on the mainframe.  Talk to your mainframe...

You really should be using DB2 Connect between SQL Server and the mainframe if you are moving anything more than a trivial amount of data.

IBM have chosen to package DB2...

Yes, I re-attached it as a user DB, but using the tempdb standard filenames.  I could then edit sysdatabases to set the dbid to 2, and SQL seemed to be...

Doing a detach & attach of Tempdb will seriously upset SQL Server.  The underlying problem is that tempdb must have a dbid of 2, but SQL prevents any attached database...

Have you checked what is happening at the mainframe end?  The 'permission denied' message may be telling the truth. 

I suggest you talk with your DB2 colleagues to try to...

You can define and use the alias [Set Disc] in the same statement using the following model SQL:

SELECT

[Set Disc] * 2 AS [New Disc]

FROM

(SELECT Value * 0.10 AS [Set Disc]...

If you want a site that does not give the very wise warning from MS, then check http://www.sql-server-performance.com/rd_traceflags.asp 

This just tells you what various trace flags do, but it is up...

If Unix System Services (USS) are enabled on the mainframe, then FTP is a recognised mainframe command.  BTW, it is all but impossible to run a mainframe nowadays without having...