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.

SQL Server probably needs an extra object with rowinformation (primary key, (non)unique index) in order to enable rowlocking.

With no index, sql server can only lock the table/page as a whole...

Got it working using

sp_addlinkedserver @server = 'SRVEXTRA'

, @srvproduct = 'SQLSERVER'

, @datasrc = 'BRANDNEW\SRVEXTRA'

...

In other words.

There is an application MyAPP thats needs info from the database "operation" on server SRVOPS (2000), default instance SRVOPS

It also needs information from database "EXTRA" located on...

Torhout, Belgium

Task manager isn't reliable above 2gb. Try Process Explorer or performance counters.

What does PF stand for? (page faults?)