... the magic reboot didn't work.

I've even removed the file from my own dev machine to make sure I was accessing the prod file.

So from ssms on dev, I can...

Not quite... drop 1200 tables and leave the 100ish used tables.

Something tells me that it might be a bad idea :hehe:.

Look a couple lines under your name and you'll see this :

Post #995597

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?