Syscomments.  Here's a query to find which stored procedures contain a specific string:

select distinct so.name from  sysobjects so

 join syscomments sc on sc.id = so.id

 left outer join  syscomments sc1 on ...

We use Lumigent Log Explorer.  It does a good job of making sense of what's recorded in the t-log whether you're looking at a current log or a backup.  See...

Try stopping and restarting SQL Server Agent after setting up the alert.

Greg

In dev and test, I tend to use the fixed database roles db_datareader & db_datawriter rather than granting permissions on tables.

In production, all table access is through stored procedures and...

When users create objects, they must qualify the object name with 'dbo' i.e.

create table dbo.mytable

Greg

DTS will work, not sure if you can replicate from Access to SQL Server.  I'd create a DTS package and schedule it as a monthly job.

Greg

There are lots of ways to do it e.g. T-SQL, DTS.  Are the old and new tables in the same database?  Same server? 

Greg

This MS article describes a tried and true way to transfer logins and associate them with database users.  I've used it many times when moving databases to new servers.

Greg

http://support.microsoft.com/kb/246133/en-us

I'd say this line is a clue, though I haven't seen this problem before.

(Microsoft OLE DB Provider for ODBC Drivers (80004005): [IBM][CLI Driver] CLI0150E  Driver not capable....

Try a DB2 discussion forum like http://www.dbforums.com/f8 or http://www-128.ibm.com/developerworks/forums/db2_forums.jsp

I'll bet you'll get more responses.

Good luck!

Greg

It's hard to say if an updateable view will work without knowing the DDL for each table, but that may be a good choice.

You could put the three inserts in...

Do you mean SQL Server Reporting Services?  See the information here for SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/default.mspx

Greg

Nope.  DTS is trying to access the text file as the login that runs SQL Server Service.  Here's the excerpt from BOL:

When xp_cmdshell is invoked by a user who is...

Create a DTS package with a Copy SQL Server Objects task that copies the objects but not the data to a documentation database (the task only works if copying between...

It sounds like you don't actually have a backup of the database that you want to recover.  Is that correct? 

If true, then I would go with your second option...