As long as only one person is running reports from a database on SQL Server that the same person is using (effectively turning SQL Server into a single-user database) then...

How are dates formatted in db2? In SQL they are yyyy-mm-dd hh:mm:ss.nnn

If DB2 is different, you'll need to use CONVERT to put the in the right format.

Check "CAST and CONVERT"...

Can you create a linked server that connects to your Access db? If so, you can insert/update your access tables via the linked server.

If not, then try using OPENDATASOURCE and/or...

Also, one thing to point out is that you can cause blocking issues in tempdb by doing SELECT INTO ... #Tmp

Better to explicitly create and drop the tables.

Hope this helps

Phill...

Check "Avoiding Deadlocks" and "Understanding and Avoiding Blocking" in Books online.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Do you have a return statement in you stored procedure? You can use the return statement to return a failure condition.

If you don't want to fail the package, use an...

What are the differences in the setup of the SQLAgent between Dev and Test?

Executing the package manually uses the credentials you used to access the server. It will also run...

Have you checked Task Manager after running the command? You'll probably find MSACCESS.EXE in the list of processes. The most likely reason it's not a visible application is because the...

Here's one I first ran across while spending some of my youth in the Army Reserves. The regular army guys always referred to us as WOFTAM's.

Waste Of F*****g Time And...

The Meta Data packages are still stored in MSDB, but they are held in a whole series of tables that are prefixed with RTbl. These are all the repository tables.

Hope...

At the moment I think it's a hard to go past mssqlXpress and Query Analyzer for development.

mssqlXpress has the advantage of Visual Sourcesafe integration. When there's something that can't be...

Those are good suggestions.

Also, take a look at the following

Both of the T-SQL books by Joe Celko.

Transact-SQL Programming

by Lee Gould, Andrew Zanevsky, Kevin Kline

SQL Server 2000 Programming by...

I've successfully done just that on a couple of occasions, haven't had any problems.

I suppose MS is just protecting themselves by not advsing users to directly update system tables.

Hope this...

Just open the package in design. Then using 'Save As...' from the Package menu, save it to 'SQL Server' instead of 'Meta Data Services'.

Hope this helps

Phill Carter

--------------------

Colt 45 - the...

DTS pacakges are stored as BLOBs in msdb..sysdtspackages. So no T-SQL query going to be able to extract the info you need.

cocr's suggestion is probably the closest you'll get...