Viewing 15 posts - 136 through 150 (of 194 total)
February 25, 2013 at 9:09 am
Absolutely, activity monitor has a drodown db filter box so select the one you are wanting to restore and then you can see what is happening. Obviously dont go...
'Only he who wanders finds new paths'
February 25, 2013 at 8:59 am
Not a database owner issue but I did run into problems when a SQL job owner had their accoutn disabled which in turn caused lots of problems. If I...
'Only he who wanders finds new paths'
February 25, 2013 at 8:40 am
May I ask, I suppose in a step by step way, what you have done so far to set up replication ?
'Only he who wanders finds new paths'
February 25, 2013 at 7:38 am
SQL Browser service running on server 2?
'Only he who wanders finds new paths'
February 25, 2013 at 3:35 am
Microsoft allows auto shrink and auto growth at the same time in SQL, it certainly doesnt mean its a wise decision to actually do it 🙂
'Only he who wanders finds new paths'
February 5, 2013 at 10:15 am
The one argument I have against this is that the more customisation that going into these stored procedures surely increases the possibility of failure. In my opinion the high...
'Only he who wanders finds new paths'
February 5, 2013 at 8:23 am
Thank you both for the replies.
Certainly altering the system sprocs are a no no, it did sound fundamentally...well wrong to me! Alternatively, having customised scripts does sound interesting....
'Only he who wanders finds new paths'
February 5, 2013 at 2:41 am
It was passed to me as an afterthought, I advised to shrink it and that was done last night. Now its simple recovery, wont be going back to full,...
'Only he who wanders finds new paths'
April 25, 2012 at 3:07 am
Well that was it, aprt from being a needlessly large file...wasnt sure if it would have any negative impact.
'Only he who wanders finds new paths'
April 25, 2012 at 2:45 am
I was indeed, even via a web app I have always created the sql logins accordingly but can see how they would be used in this way.
'Only he who wanders finds new paths'
April 24, 2012 at 7:58 am
Is it OK practice to store user details in a database table, only asking as I strictly use sql logins or windows auth?
'Only he who wanders finds new paths'
April 24, 2012 at 5:26 am
Certainly experienced the same problem when using an excel source within a foreach.
What I did find was that this issue only seemed to occur when running in design...
'Only he who wanders finds new paths'
April 17, 2012 at 5:13 am
Appreciated everyone.
The structures will be identical and yes, the data will be different. Key conflicts will be avoided by having unique key fields across all the servers. The...
'Only he who wanders finds new paths'
April 16, 2012 at 12:36 pm
I know, appreciate the response - I am after the basic guidelines really of having multiple publishers. Essentially a number of servers will have their own version of a...
'Only he who wanders finds new paths'
April 16, 2012 at 8:43 am
Viewing 15 posts - 136 through 150 (of 194 total)