Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert Into query now fails
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Insert Into query now fails
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01047519
Message ID:
01047519
Vues:
51
A Monthly Close process moves data from active tables to history tables within the same SQL 2000 database using an Insert Into query. It has been running without error for about 2 years. Recently, the workstation was upgraded from Windows 2000 Pro to Windows XP Pro (a clean install), RAM added (1.5 GB total), and the applications reinstalled. Now the Close fails on one specific query. The string passed is long but within limits. Typically there will be 12000 records of 47 fields, 18 of them text, moved between these 2 tables each time the Close is run. Any ideas why this is failing?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform