Hi george...

I tried that, but was not able too. I also found in one of Glenn Barry's blogs that there was the possibility of wiping out the securities from...

I'm still a bit confused by this. Our install has MDS, SharePoint, and other pieces (as well as the database engine and SQL services), all of which are claiming...

Awesome! Thank you!

P.S. All errors are in the SQL Agent job histories to the jobs I am trying to get to work.

Hi Nevyn...

The account in both database instances is a sysadmin equivalent account, using SQL authentication.

The problem I am having now (after making a backup of the System Master Key from...

Here is a bit more detail for better understanding. The snapshots below show you the QA and PROD systems that I am having the issue with, as well as...

That is exactly what I was looking to do, and thanks to you - I am now doing exactly that!

Thank you again Arthur, and Happy New Year to you!

😀

You were correct on doing a sanity check...The query works fine in my PROD environment, but was not working over in my QA environment. Odd thing is I literally...

Thank you, Gazareth!

I believe what happened (prior to my arrival earlier this year) was that they had all of their queries embedded in SSRS reports, and they thought it would be better...

gbritton1, thank you! The scenario you described along with what Jack has asked, should make for some better discussion on my end.

From the standpoint of pure overhead (only) -...

Jack, thank you - and yes, sorry for the lack of more specific detail. The way it was presented to me was in the fashion of the SP's currently...

Thank you Gail and Gazareth...I do not like shrinking files, and avoid doing that as often as physically possible (just didn't know if the disk space shouldn't show less being...

Resurrecting this thread since this is where my quest started. . .

I have been successfully rebuilding my database design (I think). I say I think because as I have...

Thanks to all of you for your suggestions here. I wound up going with a combination of suggestions from Eirikur Eiriksson, but also made sure that there were no...