Using a file system for images may look like the easiest to design, but it is also by far the hardest to maintain.  There have been a lot of posts...

You can change the table owner to dbo with sp_changeobjectowner.  You will have to re-link the tables in Access after doing this.

If you want any new tables from that user to...

SQL is poorer than some other DBMSs in recognising dates in character strings.  If dates are in YYYY/MM/DD format (you can use other delimiters in place of the /) your...

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...