Believe me I've googled a tone on that one.

Here's what I have working on my local, 32 bit server :

Select * from openrowset('Microsoft.ACE.OLEDB.12.0',

'Excel 8.0;Database=C:\TireGuideImport\tgpro_oe_1009_excel.xls;HDR=YES',

'select * from [tgpro_oe_1009_excel$]')

When...

Thanks... just looked it up in BOL.

I must have had it confused with query plans.

So now what the heck do I do with that DB :w00t:.

Won't those stats also go out the window as the server is under memory pressure?

I'm trying it on my prod servers and I'm having doubts about the results I'm seeing...

How the heck were you able to create the linked server in the first place??? I've been shut out on my sql 2008 standard 64 bit for months trying...

it can also be a change in set quoted_identifier... quite likely across ?5-10? years of sql server upgrades...

The closest thing to that is a trace with a filter on textdata to the name of that table.

Only you can know or find out how long to run that...

Depends on what kind of complaints you are ready to receive.

You can log every query on the server for 1 to 24 months and then scan all that to find...

Oh and there's no deciding point... if the page is modified in any way, then it HAS to be logged.

Sharepoint is more a reporting tool than a real oltp system.

It's a fair bet that you are reindexing 90% of the index in server b and only 5-10% in server...

Could be, I'd start a thread on connect to see what's really going on.

ss-457805 (9/29/2010)

---

It's backing up the database fine. but not deleting it. so eventhough i gave full control of the folder to the SQL Server service account it wasnt deleting the...

So the account had write permissions but not delete?

How come that didn't trigger any errors anywhere?

If you want to RUN the query, then hit the query... menu from the same popup screen.

Check this screenshot.

I'm using full VS 2008 pro, but you should still get that menu in express.

Ya the gui will let you make the changes and it will drop the schema bindings.

You need to re-run the scripts to create the views so that you get the...