Viewing 15 posts - 7,336 through 7,350 (of 7,471 total)
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
before you fail back check its portno.
with this script. Don't know where i've downloaded it from(author is mentioned), but it does the job.
then fail back and run it again. It...
September 11, 2003 at 12:30 am
I didn't encounter it in sql2k because I create a clustering index by default, and until now I didn't get any complaints from the app-resp. (Or they can live with...
September 9, 2003 at 2:37 am
How up to date must your data be. Do you have control on that ?
If yes, you could have a simple normalized table structure and a "relation" table. after...
September 9, 2003 at 12:19 am
I've had the same issue with a heap as Andy Warren. This was on a SQL7 sp2. Now I only REMOVE a clustered index if it's been proven it hurts...
September 9, 2003 at 12:11 am
Viewing 15 posts - 7,336 through 7,350 (of 7,471 total)