Viewing 15 posts - 7,351 through 7,365 (of 7,490 total)
- did you perform checkdisk ?
- does the server report memory-bank-problems ? (eventvwr/system)
October 22, 2003 at 5:18 am
how about this :
select e.deptno, e.ename, e.job, M.MaxSal
from emp e
inner join
(select deptno, max(sal) as MaxSal from emp group by deptno) M
on e.deptno = M.deptno
October 22, 2003 at 5:15 am
Keep it simple and stupid.
Follow Jonathan's guidelines.
October 21, 2003 at 12:48 am
It probably got into your db as result of a restore or attach from an SQL7 db.
I've noticed the same with a "convert(int(5),floatcol)"- SQL7-statement.
October 16, 2003 at 12:52 am
There 's al mass of info regarding this subject on the net.
I prefer surrogate keys because they make it mandatory for the db-user to understand the datamodel, so e.g. symantic...
October 14, 2003 at 12:06 am
works fine over here. I'd go for Allen_Cui's option.
October 10, 2003 at 12:31 am
Check your windows-eventlog and look for other (e.g. windows) lisence messages.
They might be related to your issue.
October 1, 2003 at 12:14 am
did you stop/start sqlagent ? (is needed when you activate the first alert)
October 1, 2003 at 12:10 am
use profiler to find out what's going on !
September 30, 2003 at 11:53 pm
- sometimes the apps get a timeout because the allocation of the new space takes longer than the espected time.The allocation however is executed (unless the disk is full).
- is...
September 29, 2003 at 11:57 pm
What version of SQL7.0 are you running ?
MDAC-upgrades should _always_ be tested on seperate servers that are at the level of your production server.
September 25, 2003 at 7:49 am
Any chance this is related to Q310822 ?
Check out smtp-mail at http://www.sqldev.net
September 25, 2003 at 12:21 am
I only have the alert responding when launched from within a certain database.
the first time, you'll have to stop/start SQLAgent.
Pitfall: When you disable the job which should be launched, you...
September 24, 2003 at 4:03 am
I've build a workaround to achieve this by having the users raising an alert. SqlAgent then reacts to that alert by launching a job (one per alert) that runs the...
September 24, 2003 at 1:21 am
Viewing 15 posts - 7,351 through 7,365 (of 7,490 total)