Viewing 15 posts - 346 through 360 (of 502 total)
I believe what you are looking for is the IIS setting for connection timeout.
Open Computer Management > Services and Applications > IIS > Web Sites. Then right click on the...
May 12, 2009 at 5:21 pm
Schadenfreude-Mei (4/28/2009)
We are thinking of putting in a log shrink after the backup, but i wanted to check that this was also going to be replicated to the mirror.
Yes, it...
April 28, 2009 at 4:42 pm
You could script out the permissions and create 2 jobs. 1 job to create the login and grant db access and another job to drop the login. This assumes access...
April 28, 2009 at 4:16 pm
So my questions,
1) Is my assumption here correct?
2) Is this true of all versions of sql server (sql 2000 and up)
1. You assumptions are correct. Named instance perfmons show as...
April 28, 2009 at 4:04 pm
1.) Do I need the /PAE switch?
Yes, for a 32-bit system you will need to add the /PAE switch to the boot.ini file to utilize more than 4GB of...
April 28, 2009 at 3:56 pm
absolute rubbish, the whole point of a SAN is multi pathing and fail over. Chances are, if you lose the whole SAN you've lost all building power anyway so none...
April 10, 2009 at 5:04 pm
Windows Server 2003 EE will support up to 8 nodes. Windows Server 2008 EE will support up to 16 nodes.
April 10, 2009 at 4:29 pm
Perry Whittle (4/10/2009)
April 10, 2009 at 3:44 pm
Tempdb is created from the model db which by default is 0.75MB. I don't see a way to shrink it to 512KB.
April 7, 2009 at 3:57 pm
Shrinking data files fragments objects inside the data file as SQL rearranges pages. This will effectively negate the index defrag you have just done. Unless you defrag again after the...
April 2, 2009 at 4:33 pm
In SQL 2000 you could write a script using sp_who2 and create a job to run every min and kill connections where ProgramName like 'Microsoft Office%'. That's a pretty hokey...
April 1, 2009 at 3:26 pm
You could also create a job for the DTS package and then use sp_start_job to run it.
March 30, 2009 at 3:23 pm
Check out this post: http://www.sqlservercentral.com/Forums/Topic364780-5-1.aspx
I would try adding some additional free space to the msdb database to see if that resolves the issue.
March 27, 2009 at 3:51 pm
Viewing 15 posts - 346 through 360 (of 502 total)