Turning off & on logshipping will require reinitialization. (full backup + new logfiles).

Mayhaps is it possible to delete the old data in sustainable batches for logshipping?

be sure that the correct datatypes are used , not relying on implicit conversions

I would choose 64-bit to minimize 64-to-32 bit conversions

What do folks normally use to view the data from a database if Access forms are not use? If this is more of a design question I can ask it...

Enterprise Architect can do ERD but I haven't used it much yet.

http://www.sparxsystems.com.au/

Have a look at

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/sql-server-linked-server-between-2005-64

For cannot obtain rowset you'll have to create sp_tables_info_rowset_64

I can't find the original MS KB for it at the moment

Found it:

http://support.microsoft.com/kb/906954

Raw Materials & Dilbert are of great humor to break the day.

Even ctrl+al+del is available in book/paperback.

There wouldn't be a 64-bit Jet Driver. Perhaps with the latest Office2010-64bit edition

With SSIS

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/70636/

I prefer to store the current in a live table and the history table. This way you don't have to join the live table for just 1 entry, which can...

Sometimes a reboot is required in order to fully install the oracle client

Have a look at the performance counters (windows)

SQLServer:Memory Manager: Total Server Memory (KB) : total memory for instance

SQLServer:Memory Manager: Target Server Memory (KB) : wanted memory for instance

they give an...

Consider setting max memory values for the instances. Leave some memory for the operating system (+- 2 GB)

I had the same error when using a defect install media (corrupted/incomplete iso).

With a good iso: no problems at all

It was the connection option numeric round_abort (Database Properties > Options > Numeric Round-Abort)

Would also work with end result numeric (30,18)

*Probably in combination with Cumulative hotfix 7

Thanks, I'll try uninstalling Cumulative 7 when I get approval.