Viewing 15 posts - 1,576 through 1,590 (of 7,498 total)
- can both instances communicate using those port numbers ? (firewall, ..)
- did you install the certificates correct ?
December 1, 2011 at 5:27 am
Do you have deadlock reporting in SQLServer errorlog enabled ?
This can be accomplished using startup trace flags
-T1204
-T3605
and so you don't need to restart you instance you can enable it for...
November 30, 2011 at 12:11 pm
Trace Flag 8017 upgrade version conflict http://social.msdn.microsoft.com/Forums/eu/sqlexpress/thread/dd6fdc16-9d8d-4186-9549-85ba4c322d10
November 28, 2011 at 1:40 pm
Great job, Roy.
It's been my pleasure to help out.:smooooth:
November 28, 2011 at 10:18 am
Dev (11/28/2011)
Lynn Pettis (11/24/2011)
Dev (11/24/2011)
They may not remember and that is why it should be declared as NOT NULL.
Well, I guess we will have to agree...
November 28, 2011 at 8:03 am
Of course there columns will only get you the latest info. Intermediate modifications will not be shown at all.
You may also have a look at Tracking Changes in Your Enterprise...
November 24, 2011 at 1:37 am
I tend to add those columns. (period) and don't maintain them to be first or last in the list.
I don't rely on sprocs to fill out their values.
They...
November 23, 2011 at 11:47 am
GilaMonster (11/23/2011)
ALZDBA (11/23/2011)
What where the results your the dbcc you ran on the suspect db.
CheckDB can't be run on a suspect database, it has to be set to emergency mode...
November 23, 2011 at 11:39 am
Step 1 : Don't panic !
Step 2: keep your head cool !(if you don't, who will ?)
...
What where the results your the dbcc you ran on the suspect db.
Especially Gail...
November 23, 2011 at 9:21 am
If you can try to avoid the scalar value function ...
this may be worth a shot :
UPDATE Z
SET VesselCount = C.vesselCount
from ZoneBlocks...
November 22, 2011 at 5:54 am
Can you include sample data for the [AISPositionsCurrent] table ?
November 22, 2011 at 5:42 am
Dev (11/22/2011)
Cadavre (11/22/2011)
Repost.Probably should have just asked Steve to move the original (when he gets back) if you thought it was better suited here.
In fact I...
November 22, 2011 at 4:18 am
Why don't you just directly perform the update ?
What's inside the function dbo.GetZoneBlockCount ?
November 22, 2011 at 4:16 am
Did you set the upper limit for SQLServer am to be used ?
sp_configure 'max server memory' --, 13500 show the current value
sp_configure 'max server memory', 13500
With a 16GB server I...
November 22, 2011 at 3:38 am
Keep in mind columns with the identity property are meant to generate their own value in a given sequence.
(check books online for seed and increment)
However - as replied by the...
November 22, 2011 at 2:39 am
Viewing 15 posts - 1,576 through 1,590 (of 7,498 total)