Ok all the final word on Jet

The Microsoft OLE DB Provider for Jet and the Microsoft Access ODBC driver are available in 32-bit versions only

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

So frankly what this...

Dam copiers....

My dual post (of my own writing) to help those that might think upgrading to 64 bit is a good idea.

Ok all the final word on Jet

The Microsoft...

Ok all the final word on Jet

The Microsoft OLE DB Provider for Jet and the Microsoft Access ODBC driver are available in 32-bit versions only

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

So frankly what this...

I'm in SQL 2008 64bit clustered this is my unhappiness

Error/Information message I receive

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

Query I'm running

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=C:\SqlServerInstances.xls;Extended Properties=Excel 8.0')...[Customers$]

Am I...

Stop the flame. My eyes hurt....

Bill gates I can't remember to many times I seen that man in a tie. In fact before he got married he looked a well let's just say not...

No sp_configure talk?

Should I turn parallelism on or off hahahha!!!

Are we just Gui's these days?

Brian your voice sounds different in person.

Loved the Analysis service class last April.

T

Not to be well mean. But building a restore next to a prod DB and comparing data should be what we always do. I'm mean your just sewing...

Old Hand,

Check the table your inserting into for a trigger. If you have an after trigger that fires those commands in the trigger will flush the value in @@error...

Hmm,

The first thought that came to me isn't this what I've use derived tables and identities for in the past.

I won't guarantee performance want suffer of be less then using...

Sorry to be Lazy or maybe just an american?

Anyway I know there is a meaning behind this in the code.

e(x)

I just can't seem to figure out what. One of...

Sorry to open an old thread but I'm fishing for some perspective and hope there are pople out there that can help.

I have several inhouse DB's that long...

All,

This part of the article below has me the tiniest bit flustered as I believe it can take newbie’s down the wrong road.

Author-- "As TRUNCATE resets the identity column counter,...

Steve,

I eagerly await your new article on this subject. If there is anything I can add it would be this. Not all database requirements are a one size...

Steve,

I'm curious about your take on this subject.  Under the why upgrade section the basic point your expounding into our heads is that of support timelines.  As such it looks...