It should run OK on SQL 2012.

You know, it's been so long I don't remember. Maybe delete them from your profile and if the problem persists, delete, move or rename them from others?

Shaun

That statement runs without errors.

Sorry - SQL 2008 R2 SP2.

Jason - yes - tried exporting from SSMS on my workstation, on the server itself. Tried accessing it using BIDS from both locations. Nothing works.

opc.three...

Sorry, I never figured anything out with regards to this. I've since moved on to a different company and no longer have anything similar in my current environment.

Just to bring some closure to this.. The issue seemed to be similar to the one posted in this thread: http://www.sqlservercentral.com/Forums/Topic1262389-391-4.aspx

However, the solution to that issue (caspol.exe -machine...

I managed to find some logs by searching the entire hard drive for recently created files. Turns out, the log was at C:\Users\<username>\AppData\Local\Temp\SqlSetup.log. Details in the log are:

08/02/2012 06:54:45.744 Required...

I thought I found the problem, but still no.. I was attempting some Windows Updates and saw ones for .NET 4 Framework were failing. I went into Add / Remove...

\??\C:\Users\SHASTU~1\AppData\Local\Temp\2\PCW2543.xml

\??\C:\Users\SHASTU~1\AppData\Local\Temp\2\PCW2543.tmp

\??\D:\Config.Msi\fcec26.rbf

Not sure what you mean by a different installer. But I did just install the SP on another server that had the same .NET versions without problems.

Add / Remove Porgrams shows Framework 4 Client Profile and Framework 4 Extended. The ASoft .NET Version Dectector XI program shows .Net 2.0 SP2, 3.0 SP2, 3.5 SP1, and 4.0...

I think the way to do it (or at least one way to do it) is to check the restorehistory table and look for a restore with a date after...

Hmm.. That doesn't appear to be the case for me.. My fork_point_lsn values are all null for this database.

I also run a DBCC CHECKDB WITH DATA_PURITY. Well, more accuratly, I check to see if it needs to be run. Check out Paul Randal's post on how to determine...

Aha! That was it! Thanks!

Shaun