Viewing 15 posts - 751 through 765 (of 853 total)
My model is sat to ful and msdb is set to simple. The jobs were running fine before and just strat failling.
October 31, 2008 at 9:47 am
For this server I am not facing any problems. I need to know if this server is sat properly. I am trying to see if server has enough memory, to...
October 31, 2008 at 8:26 am
I am new with DB and new at my work and trying to figure out and get some help if my server is setup properly. Thank you
October 31, 2008 at 8:06 am
recovery interval (min)03276700
allow updates0100
user connections03276700
locks5000214748364700
open objects0214748364700
fill factor (%)010000
media retention036500
nested triggers0111
remote access0111
two digit year cutoff1753999920492049
default full-text language0214748364710331033
default language0999900
max worker threads3232767255255
remote proc trans0100
network packet size (B)5123276740964096
index create memory (KB)704214748364700
priority boost0100
show advanced options0111
remote...
October 31, 2008 at 7:42 am
This is what I have
affinity mask-2147483648214748364700
allow updates0100
awe enabled0100
c2 audit mode0100
cost threshold for parallelism03276755
Cross DB Ownership Chaining0111
cursor threshold-12147483647-1-1
default full-text language0214748364710331033
default language0999900
fill factor (%)010000
index create memory (KB)704214748364700
lightweight pooling0100
locks5000214748364700
max degree of parallelism03200
max server...
October 30, 2008 at 11:00 am
So you are saying I can leave it as minimum 0?Thank you
October 30, 2008 at 8:40 am
My space is on RAM 7935. My minimum server memory on the server (I got it from server properties is 0 MB) and maximum is 2147483647 on the server. Is...
October 30, 2008 at 7:28 am
I check
C13018
E305935
What else it could be, My server is very slow,how can I check if there is any jobs are running against this server?
October 29, 2008 at 7:42 am
I don't know if I have enough space. Can you please help me. I have on my server:2147483647 in MB and my each db contains:
2048.75 MB
...
October 29, 2008 at 7:11 am
I need to know which database was used last, I don't care which user, all I need if the database was used by anyone within 6 month
October 27, 2008 at 7:25 pm
where do I run sp_help_revlogin
October 13, 2008 at 1:58 pm
Thank you, I get copy of my logins but password is not correct, any idea why?
October 13, 2008 at 12:48 pm
Viewing 15 posts - 751 through 765 (of 853 total)