Viewing 15 posts - 1 through 15 (of 170 total)
I can't find a way to delete this post so I just want to supply an update. The EXECUTE on the stored procedures worked just fine. The issue was in...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
April 7, 2020 at 3:32 pm
OK, I was finally able to make the change and make this user part of the db_owner role. It took this long because I had to wait for our scheduled...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
August 19, 2019 at 8:51 pm
Sorry I am just now getting back to responding.
I have played with the timeouts and let it run a long time. I decided to try it again this morning and...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
August 8, 2019 at 5:30 pm
Thanks for responding and at least letting me know I haven't lost my mind about not being able to find anything. The strange thing is, these instances are default instances...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
May 16, 2019 at 1:29 pm
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
April 2, 2018 at 9:58 am
Please excuse my delay in responding and my somewhat incomplete description of the situation. I put this post together rather hastily and did not do a good job of proofreading. ---------------------------------------------------------- 01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
April 2, 2018 at 6:48 am
Thank you Jacob, I definitely got tunnel vision on this one. I am aware of what you are talking about and, now that you say it, it makes perfect sense. ...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
July 27, 2017 at 12:41 pm
Restoring the system databases wouldn't help reset any settings within the user database being restored. The purpose of this script is to re-apply users, database roles, and role memberships after...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
May 1, 2017 at 7:55 am
Sean Lange, no worries! I don't take any offense at a good conversation on here. We're all here to learn, no matter how long we've been doing this. Actually, the...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
January 30, 2017 at 1:24 pm
gvoshol 73146, the script has now been updated to include the schema in the output.
Sean Lange, I have heard about some problems with this undocumented procedure but I...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
January 30, 2017 at 10:05 am
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
January 30, 2017 at 7:57 am
Here is an update on what the issue was for me. Exit code 5 is an "access denied" code. The problem had to do with UAC settings on...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
June 2, 2016 at 12:55 pm
Sorry that I'm a little late to the party but this was an excellent article to help me get this monitoring setup in our environment. It has already helped...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
February 11, 2013 at 1:54 pm
I just wanted to follow-up with what happened with this issue.
After nearly bringing the system to its knees by running Profiler traces to find ALL of the locking, and other...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
January 31, 2013 at 11:49 am
Standard Edition
10.0.4000.0
SP2
There are no DML triggers. I have scripted out everything as well as checking the included objects, in multiple ways.
I cannot figure this out. I...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
January 28, 2013 at 8:03 am
Viewing 15 posts - 1 through 15 (of 170 total)