We use CLRs (have for some times) with custom C# code. Previously, it ran on all of our customer-facing SQL servers (non-SSRS report servers), now only one server uses it...

You could write a script to BCP out the data?

Here is something I run to generate data from a table to convert it into a SELECT statement:

USE MyDatabase

Go

DECLARE...

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://qa.sqlservercentral.com/articles/SQL+Jobs/68764/) per my understanding?

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

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