Viewing 15 posts - 1,576 through 1,590 (of 7,502 total)
Is your query "select Users.UserName from Users" producing results ?
Are there usernames that return NULL in stead of a valid value ?
Did you notice
Msg 512, Level 16, State 1,...
December 5, 2011 at 12:03 am
aim for uniformity of management and apply the same backup strategy on all your instances.
If you cannot do that, use sqlagent to schedule your backup jobs for the wanted databases.
Double...
December 4, 2011 at 11:58 pm
just a little but crucial warning;
- double check your jobs aren't launched using sqlalert(s) ! If a jobs can be launched by a trigger and you disable the job, when...
December 1, 2011 at 1:56 pm
- 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
Viewing 15 posts - 1,576 through 1,590 (of 7,502 total)