I found this kb article, hope it helps

http://support.microsoft.com/?kbid=815431

If I move to an ADP I lose some functionality (easily making cross tab...) As well I need to make it Access 97 compatible.

I believe that MS SQL Exec will create script create and insert queries based on your data. Its a freebee here at http://www.sqlservercentral.com/products/#freeware Under tools and generate SQL...

What about using a VPN, then terminal servicing in?

One of my most favorite undocumented things in query analyzer is the object browser, and the fact that if you drill down to the table or view and drag and...

tcuscino your a genius! That was it, I was starting to have some goofy problems all around and unhiding the servers (back to 1433) took care the sqlmgr error as...

Assuming 1 raid 5, I completely disagree with having 1 big partition. for 1 huge reason. Recovery. If your os fails, reload it and your apps to the one partition...

I tried each even looked at MTU's. When I look at the switch there is no activity between the server and the TS box. However when I run the same...

I have the exact problem on 2 instances of sql server 2000. Both instances are windows 2000 sp3. Both instances had all services stopped before I loaded the patch. Both...

I would highly recommend that you test your setup. We migrated our PeopleSoft from DB2 to Oracle and PeopleSoft was also very tight lipped. And we ran into huge problems,...

Also look at the web browser in the Sql Server 2000 resource kit or on the web at http://groups.msn.com/OLAPServicesDevelopersForum/web.msnw?action=get_message&mview=0&ID_Message=45&LastModified=4675405111138581414

I have found with any open source system, you will typically make up any difference in cost through employee hours in making the system work. For example, MySQL does not...

Storing BLOBs in SQL Server, or an RDBMS is not really fun. The SQL Server 2000 Resource Kit has an example (Bii.exe) that is useful for an example. As well...

I found database journal had some good into lessons such as: http://www.databasejournal.com/features/mssql/article.php/1429671

or

http://www.databasejournal.com/features/mssql/article.php/1497971

The best way to learn it to use your own data, as you will...

First you should look at your data types in Access. Access can store some non-standard dates and times. For example Access can store a time as 4:55:02 AM SQL Server...