Viewing 15 posts - 9,181 through 9,195 (of 9,241 total)
do you have a firewall enabled?
if so check the firewall log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 10:38 am
ALZDBA (6/16/2008)
If you license an instance on a physical server, you license per cpu socket.
With virtual servers, you license per available cpu (i.e. cpu-core...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 10:34 am
some brilliant links and advice there, way to go guys 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 10:01 am
this shrinking malarky has been done to death all over the forum:D
good job cos i learnt something new 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 10:00 am
from memory, (forgive the pun) Windows 2003 server Enterprise shouldnt need a /PAE switch.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 9:56 am
GilaMonster (7/14/2008)
ltoso (7/11/2008)
There should be a firewall. A web-facng server without a firewall is just asking for various forms of trouble.
that's the thing that worried me, how can public ip's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 9:53 am
check this link
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1721211&SiteID=1
it may be of some use
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2008 at 3:49 pm
are you sure you wanteed to audit all tables, that is quite an overhead to place on the database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2008 at 3:41 pm
installing sql2005 express should be no more than if you were installing another sql2000 instance.
Install a named instance and then remove it when you're done if you want to
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2008 at 7:21 am
TRACEY (7/12/2008)
How did you get 129
i'm assuming he got it from here
TRACEY (7/12/2008)
Trying to determine what the measurements are in profiler in MG and GIG
Divide by...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2008 at 7:16 am
Mani Singh (7/12/2008)
you need to ensure that the folder structure and the drive letter are kept the same.
especially the folder permissions, that applies to SQL whether clustered or not
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2008 at 6:46 am
DKG (7/12/2008)
As per my understanding log file contains uncommitted transactions only, the transaction which is already committed has gone to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2008 at 6:44 am
are you using redundant HBA's? It would be advisable
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 2:58 pm
change this
create proc procname
@subject1 int,
@subject2 int,
@subject3 int,
@result int output
as
set @result = @subject1+@subject2+@subject3
to this
create proc procname
@subject1 int,
@subject2 int,
@subject3 int,
as
declare @result int
set @result = @subject1+@subject2+@subject3
it will only expect 3...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 2:47 pm
are you using a static or dynamic IP address for the windows 2003 server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 1:08 pm
Viewing 15 posts - 9,181 through 9,195 (of 9,241 total)