Viewing 15 posts - 1 through 15 (of 488 total)
Yesterday, I removed mirroring for this database and set it up again. That solved the problem.
Unfortunately, it doesn't tell me what caused the problem so that I can...
October 19, 2017 at 12:34 pm
At one point I thought this problem might be permission related because the error in the SQL Server log starts out with "Login failed for user..." However this error and...
May 15, 2017 at 11:52 am
Any database that is offline doesn't show up in the list of databases available for backups.
When I switch a maintenance plan from all database to those I specify...
May 15, 2017 at 8:23 am
I thank you all for your replies so far. As I have been going through them and getting ideas on what to look at I have been narrowing down the...
May 12, 2017 at 2:59 pm
It looks like I was looking in the right place for the maintenance plan logs and they don't offer any useful information about the error I am getting.
May 12, 2017 at 8:09 am
I have considered scripting the t-sql from the plans and using that code as a temporary fix, however I prefer to keep using the maintenance plans.
Has anyone dealt...
May 11, 2017 at 2:51 pm
Thank you both for your patience and for explaining things I did not understand nor consider as I thought about this. I begin to see how this becomes more complex...
August 26, 2015 at 2:05 pm
I guess it would have helped if I had explained better.
The deadlocks I see the most often are with two SPIDS having a page lock on the same index...
August 26, 2015 at 1:03 pm
Thanks for the quick reply. I suspected that might be the answer but wanted to be sure it wasn't just me missing something, like some undocumented DBCC that didn't come...
August 26, 2015 at 11:58 am
I hate when problems are so simple I can't figure them out. I just figured out the problem. I needed to include both columns in the Source Columns...
February 25, 2009 at 10:44 am
I think I have found what you are talking about.
I select configuration type as parent package variable and then tell it to put whatever is in that package variable into...
July 10, 2008 at 10:25 am
I learned about how tables relate to each other at my current job by talking with people who were here before me and modifying existing SP's to add new features....
January 14, 2008 at 8:23 am
Another thought is that if the SP that everyone is running can return a different number of rows depending on what parameters are sent into the SP then the user...
January 14, 2008 at 8:01 am
I forgot about that. Yes I am on call too and had to work 40 minutes from home this past Saturday. The thing is officially the time you...
January 14, 2008 at 6:25 am
Thanks for all your help!:)
October 29, 2007 at 12:47 pm