Viewing 15 posts - 136 through 150 (of 193 total)
Might get you started...
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...
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...
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 ?
February 25, 2013 at 7:38 am
SQL Browser service running on server 2?
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 🙂
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...
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....
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,...
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.
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.
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?
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...
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...
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...
April 16, 2012 at 8:43 am
Viewing 15 posts - 136 through 150 (of 193 total)