Viewing 15 posts - 1 through 15 (of 17 total)
Apologies that I am slow in replying, thanks to those who replied. I did query the default trace files, unfortunately they did not go back far enough to capture the...
May 17, 2018 at 9:37 am
Just an update... CHECKDB found 0 allocation errors and 0 consistency errors in database and we are unable to reproduce the error on a copy of the db. I guess we'll...
October 13, 2017 at 12:29 pm
This turned out to be a delegation setting in Active Directory.
January 5, 2016 at 10:57 am
Thanks Grant for your time and hopefully the thread will help others in the future! It's a weird one.
October 31, 2014 at 5:14 am
Good News…
After installing the Service Pack 2 (SQLServer2008R2SP2-KB2630458-x64-ENU.exe), the issue is resolved.
October 30, 2014 at 11:55 am
Thanks, I will do that. Nice to know I'm not going crazy.
October 30, 2014 at 10:41 am
I should also add that I know the backup is not corrupt because I am able to restore it on a 10.0.5520 instance.
October 30, 2014 at 8:35 am
I should add that several other db backups from the same 2008 server DID restore fine on the 2008 R2 instance. Could it be one feature in the failing...
October 30, 2014 at 8:33 am
On production (which works), when I view permissions for the given user/database, Explicit tab, I see Grant checked for
Connect
Execute
Insert
Select
Update
The Effective tab shows all of above plus Delete.
The login/user...
May 9, 2012 at 9:14 am
Slight correction- actually the new .bak is 500 mb smaller than the original. But even compressed shouldn't a 250 gb reduction in log file size result in more than...
February 17, 2012 at 5:39 pm
The desire for a single sp is so that a non-sql dev group can run it easily and repeatedly- they need to compare the resulting data when run thru different...
February 20, 2011 at 9:57 am
Thanks for the great feedback to all who responded, it's been very helpful. I *fixed* the code using CASE statements, but wrote up options and recommendations for refactoring.
December 21, 2010 at 11:17 am
I will try the CASE solution for the one sp that is currently a roadblock. Unfortunately we have many stored procedures (with more on the way) that have this...
December 21, 2010 at 7:37 am
Thanks to both of you, much more elegant than the grunt code I had come up with.
May 10, 2010 at 2:34 pm
m% (wildcard) must match a patient field (such as Michael or Maya)
a% must match a DIFFERENT patient field (such as Ayers or Anne)
a% must match a DIFFERENT patient field...
January 19, 2010 at 9:10 pm
Viewing 15 posts - 1 through 15 (of 17 total)