I know this is an older post, but we just ran into a similar problem and "googling" the issue, this was only one of two responses that came up.

We...

I totally agree about blindly accepting missing index recommendations! 🙂

We run a process weekly that checks the server uptime (3 days or greater is our criteria), then capture all of...

Sorry for any confusion... I believe there are a few levels of "ownership" (http://www.sqlservercentral.com/articles/SQL+Jobs/68764/) per my understanding?

1) The account that is configured to run SQL Server Agent service.

2)...

Not what you may want to hear, but have you may have to convert the process (temporarily) to use a different methodology, if it is that important?

- Are you...

Nope. No proxies.

The job is actually run with a custom higher level account with full permissions in every database. Yes, it has full SA permissions... again, please no discussions...

Sorry for taking so long to response back on this... I know I personally do not like it when a thread suddenly "quits" without any resolution, especially when I am...

Did you check to see if Network Service has permissions in the new instance?

USE Master

GO

select left(name,25) name, type, type_desc

from sys.server_principals AS log

WHERE (log.type in ('U', 'G',...

Ok... I was finally able to jump back on this problem and get it resolved:

1) Did a full backup this AM.

2) Detached the database.

3) Renamed the LDF...

Gail,

Thanks for the response! I am worried that a restore may be in order, but that usually takes 2-3 days, due to the size of the database (853 GB...

LOL. Sorry... problem with being at work with a cold? Not enough coffee yet? Actually, I ran both DBCC CheckDB (last week) and CHKDSK (today), no errors with either.

I...

Even though this is an older post, some (like me) researching this might find this useful:

Apparently, setting the "Tablix properties" is only good for a Matrix and not a...

I had a similar issue (tried to install Replication after the initial install/patch of SP). Trying to run via the Media (Setup.exe) and adding replication failed (version issue error messages)....

That said, if you are fortunate enough to have a complete lineage-impact matrix of your entire solution and can accommodate all downstream dependencies, a suitable script would be a valuable...

Thanks for that link. 🙂

We reviewed...

Unfortunately, since the the Stored Procedure pegs the CPU at 100% (and this is a Production system), the Execution plan cannot be viewed as it appears to stop running at...