Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which column causes the problem?
Message
De
22/03/2015 20:07:42
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Web
Divers
Thread ID:
01617084
Message ID:
01617093
Vues:
24
>>Or else they have fixed the "file not found" which never tells you which file was it. It's unchanged since 1981 or thereabouts. This immediate amnesia, where the code immediately forgets which file/field/routine caused the error, is a long standing feature which will live longer than we do.
>
>I agree that "fine not found" is very annoying message; to say the least.

All such messages are highly irritating. Your database tool doesn't know which field it was doing when the error happened? I'm seriously underwhelmed (well nobody gets whelmed right, for that matter).

>I had to find the "offending" field using the old-fashioned method of commenting one or two fields at a time.

When it's one among few dozen (and I've had up to 120 sometimes), binary search does it. Comment the first half, give it a try. If it still breaks, uncomment that and comment half of the other half, or else uncomment half of that first half. Much faster than eyeballing.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform