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...

Gianluca Sartori (3/14/2012)

---

If you have enough space in the tempdb drive, you could use SORT_IN_TEMPDB.

Another option is adding temporarily a new data file in the same filegroup in a different...

Thanks for the updates/inputs! 🙂

Everything we do (queries) is very "date-centric" so Date is almost always a part of the clustered indexes on our tables, FYI.... date of a...