Version imprimable
Bonjour,
Voici mon problème:
Pièce jointe 530677
Je ne peux rien faire directement dans le Manager.
Le typage est bon, vérifié et revérifié.
Même la suppression n'est pas possible.
Je tourne sous SQL Server 2017. la màj est récente.
Si quelqu'un a une idée, merci.
as-tu des déclencheurs sur la table incriminée ?
https://support.microsoft.com/fr-ma/...osoft-sql-serv
Non, , absolument aucun, le répertoire Déclencheurs est vide
Table simple, une seule clé, pas de contraintes
Vérifiez la version de SSMS et de SQL Server. Prenez la dernière version de SSMS.
A +
Je suis sous v18.4 pour SSMS et SQL Serveur 2017 est à jour.
En fait, après investigation, je m'aperçois que ce sont les deux champs "text" de la table qui posent problème.
Il s'agit de type "text" en base 64 (images encodées en base 64).
Mais je ne vois pas pourquoi...
exemple:
iVBORw0KGgoAAAANSUhEUgAAArAAAAMaCAYAAAB+tHWKAAAABHNCSVQICAgIfAhkiAAAIABJREFUeJzt3TGC48i1JdBozRjyYMrDDrADroQr+eashivBDrADmLIKpiyNoY762VAyCZAAIh5wjqPuFrMysoqVdXnr8cUfv379+ncCAIAg/lb6AAAAsIYACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKP+39AEAeG6apjSOY5qmKaWUUtM0qW3b1DRN4ZMBlCPAAlRsHMf0eDzSMAwppZS6rkv3+z11XVf4ZADlCLAAFZk3rsMwpL7vfwfYaZpS27YppaSJBS5LgAWoyLxxzYF2/v+P46iJBS5LgAWoQA6qfd//pXH97nHDMKSmaX63tABXI8ACVCA3q33f/6VxBeC/WaMFAEAoAixABdq2Tff7Pd3v999v0gLge0YIACrQNE3qui5N02SzAMALGlgAAEIRYAECytsIhmGwjQC4HAEWIKC8tSDvhAW4EjOwABX5Ogv79UauudzAppTczAVczv/5n//5n/9X+hAA/Mff//7330F0HMf0z3/+88fH/+tf//oddNu2Tf/4xz8OOilAORpYgIqs3UbgZi7giszAAgAQigALUKHcxHZdZ64VYEaABaiQm7kAnjMDC1AhN3MBPKeBBQAgFAEWAIBQBFgAAEIRYAEACEWABQAgFAEWAIBQBFgAAEIRYAEACEWABQAgFDdxAVRomqY0jmMahiFN01T6OABVEWABKjSOY3o8Hqnv+zSOY+njAFRFgAWo0DRNaRiGNAzDj49rmia1bZu6rktN0xx0OoCyBFiAwNq2Tff7Pd1ut9S2benjABxCgAUIrGma1HVd6rqu9FEADmMLAQAAoQiwAACEIsACABCKAAsAQCgCLAAAoQiwAIF93Rfrxi7gKgRYgMDyjV2Px8ONXcBlCLAAAITiIgOAwNzEBVyRAAsQmJu4gCsyQgAAQCgCLAAAoQiwAACEIsACABCKAAsAQCgCLAAAoQiwAACEYg8sQEWmaUrjOKZhGNI0TaWPA1AlARagIuM4psfjkfq+T+M4lj4OQJUEWICKTNOUhmFIwzD8+LimaVLbtqnrutQ0zUGnA6iDAAsQUNu26X6/p9vtltq2LX0cgEMJsAABNU2Tuq5LXdeVPgrA4WwhAAAgFAEWAIBQBFgAAEIRYAEACEWABQAgFAEWAIBQBFgAAEKxBxagAtM0pXEc0zAMaZqm0scBqJoAC1CBcRzT4/FIfd+ncRxLHwegagIsQAWmaUrDMKRhGH58XNM0qW3b1HVdaprmoNMB1EWABQikbdt0v9/T7XZLbduWPg5AEQIsQCBN06Su61LXdaWPAlCMLQQAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKPbAAhQ0TVMaxzENw5CmaSp9HIAQBFiAgsZxTI/HI/V9n8ZxLH0cgBAEWICCpmlKwzCkYRh+fFzTNKlt29R1XWqa5qDTAdRJgAUIoG3bdL/f0+12S23blj4OQFECLEAATdOkrutS13WljwJQnC0EAACEIsACABCKAAsAQCgCLAAAoQiwAACEIsACABCKAAsAQCj2wAIUME1TGscxDcOQpmkqfRyAUARYgALGcUyPxyP1fZ/GcSx9HIBQBFiAAqZpSsMwpGEYfnxc0zSpbdvUdV1qmuag0wHUTYAFqFjbtul+v6fb7Zbati19HIAqCLAAFWuaJnVdl7quK30UgGrYQgAAQCgCLAAAoQiwAACEIsACABCKAAsAQCgCLAAAoQiwAACEYg8swIGmaUrjOKZhGNI0TaWPAxCSAAtwoHEc0+PxSH3fp3EcSx8HICQBFuBA0zSlYRjSMAw/Pq5pmtS2beq6LjVNc9DpAGIQYAEq1LZtut/v6Xa7pbZtSx8HoCoCLECFmqZJXdelrutKHwWgOrYQAAAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKHYAwtwgGma0jiOaRiGNE1T6eMAhCbAAhxgHMf0eDxS3/dpHMfSxwEITYAFOMA0TWkYhjQMw4+Pa5omtW2buq5LTdMcdDqAWARYgIq0bZvu93u63W6pbdvSxwGokgALUJGmaVLXdanrutJHAaiWLQQAAIQiwAIAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKPbAAuxomqY0jmMahiFN01T6OACnIMAC7Ggcx/R4PFLf92kcx9LHATgFARZgR9M0pWEY0jAMPz6uaZrUtm3qui41TXPQ6QBiEmABKtC2bbrf7+l2u6W2bUsfB6BqAixABZqmSV3Xpa7rSh8FoHq2EAAAEIoACwBAKAIsAAChCLAAAIQiwAIAEIoACwBAKAIsAACh2AMLsINpmtI4jmkYhjRNU+njAJyKAAuwg3Ec0+PxSH3fp3EcSx8H4FQEWIAdTNOUhmFIwzD8+LimaVLbtqnrutQ0zUGnA4hNgAUoqG3bdL/f0+12S23blj4OQAgCLMCG1s6+Nk2Tuq5LXdcdcDqAcxBgATZk9hVgfwIswIbMvgLsT4AFKMDsK8D7BFiAAsy+ArzPTVwAAISigQXYgJu3AI4jwAJswPYBgOMIsAAbsH0A4DgCLMCBbB8A+JwAC3Ag2wcAPmcLAQAAoWhgAT5g+wDA8QRYgA/YPgBwPAEW4AO2DwAcT4AFOIDtAwDbEWABDmD7AMB2bCEAACAUDSzAG2wfAChHgAV4g+0DAOUIsABvsH0AoBwBFmBHtg8AbE+ABdiR7QMA27OFAACAUDSwACvYPgBQngALsILtAwDlCbAAK9g+AFCeAAuwA9sHAPYjwALswPYBgP3YQgAAQCgaWIAFlm4fMPsKsD8BFmCBpdsHzL4C7E+ABVhgzfYBs68A+zIDCwBAKBpYgB+4eQugPgIswA/cvAVQHwEW4Adu3gKojwALsAHbBwCOI8ACbMD2AYDj2EIAAEAoGliAb9g+AFAvARbgG7YPANRLgAX4hu0DAPUSYAE+YPsAwPEEWIAP2D4AcDxbCAAACEUDC/CF7QMA9RNgAb6wfQCgfgIswBe2DwDUT4AFeIPtAwDlCLAAb7B9AKAcWwgAAAhFAwuQbB8AiESABUi2DwBEIsACJNsHACIRYAFWsH0AoDwBFmAF2wcAyrOFAACAUDSwwKXZPgAQjwALXJrtAwDxCLDApdk+ABCPAAuwgO0DAPUQYAEWsH0AoB62EAAAEIoGFrgk2wcA4hJggUuyfQAgLgEWuCTbBwDiEmABfmD7AEB9BFj4UJ6lNEcZy9LZV9sHAOojwMKH8izlq7+Kpi75hQcA8Qiw8Kd3m9RhGFLf9wLsSeVZ2VfyrKw5WYD9/fHr169/lz4E1GAYhreaVCME57Y0mHZdl+73u1EDgANoYDkdTSpbWtrATtOU2rbd7IVMDs4ppd+jDhpegP/QwHI6mlRK2HqEIDe6KaX0eDxSSknDC/AnDSzhvAqamlRKWNrUrvnxcgPb931KKX3b8Jq9Ba5IA0s4rxpWTSpnsHSEwOwtcEUaWKqjYYXvG93vnvPz2VuNLHAFGliqo2GF5eaBVSMLXIEGlsOdrWHVeNXt7C945k3ts20InqfAmWhgOdzZGlaNV93e3UoR1bOg6nkKnIkGlsPlxii/s7oW7zZUXdel2+0mGFRm7VWxnzaUtbzwerYNQTMLnIkAC39q2/athurru8WpxziO6fF4pL7vFwXZd3/9s9qb3vzzoZkFzkCA5bTWNkua1HPJTeTSQNk0ze/nwDuapknjOG7WZG7d6GpmgTMRYDmttY2aJpVP5OfbVoHzqEZXMwtEJMASztJmSKN6Tbm5HIZhUZjMz6eu6z5qG3ODu5VXje5WDa1mFohIgCWcpc2qRvWa3p19vd1uVT1fXjW6eze0mlmgZgIs1fppHZBmlWeWzr7m59ftdqvy+fSq0X3W0B7VzKb0/dW2AEcQYKnWs6ZVs8oWam1el3rW0B7VzI7jqIkFihFgOdzSWUFNK2u8M/vadV3Y59ez30fzZnavbQZN0xTfeQtclwDL4Za+W1vTyhprZ1/Pav77q/b9tADvEGA53Nbv1oaU1s++frp1oFbz3197zcp+bWLNwgJHE2CBS4k++7rWXrOyZmGBkgRYILSrzb6utXRWNlvazJqFBUoSYIHQzL6+p9QWA4AtCLBAaGZf3/OqmU0prW5izcICR/lb6QMAHCE3jvf7/RKzr+9a+/OUG/A8DwtwBA0sEJLZ1318bWaXNLFmYYESNLBASJq/fWmsgZppYIGQzL7uKzex0zQt+nkzCwscSQMLnJom8RgaceBIGlggFLOvx/raxC6ZhU0p/X6hoIkF9qKBBULR9B3LVgKgRhpYIBSzr8f6ZBbWVgJgLwIscEq5ObzdbmZfAU5GgAVCMPta1tJZ2MxWAmBPZmCBEMxWlmUWFqiJBhYIwexrWW7oAmqigQVOxd7Xffn5BWqggQWqZva1Lu9uJfj68WZigU8JsEDV8ixl3/dmKQPKv345sHZdl+73uxcYwEcEWKBqZl/r9M4NXV//G8AnzMACp2A281h+voGSNLBAlcy+1m3tLCzAlgRYoEpmXwF4RoAFqpKb177vU9/3Zl8r9U5D7tcJ2IoAC1RlbfOaZzFvt5tZzAP5dQJKEmCBqizdOpCZfT3Wuw357XZLt9vNrxOwCQEWgMU0r0ANBFigCmYqY9CQAzUQYIEqaPYAWEqABaqg2aubhhyoiQALwEsacqAmAixQlGYvBg05UBMBFihKswfAWgIsUNTSZs8+0TI05ECNBFggBM1rGRpyoEYCLFDEO82emcrjuHELqJkACxSxttnjWJpXoGYCLFDE2tlXM5X7yo1rbsOHYVjUvGYacuBIAixQNc3eMXLjmgNrDrQANRJggUOZfS1r3rRmaxtXgJIEWOBQZl/LmjetmcYViESABQ5l9vUYmlbgzARYoEpmXz+jaQXOTIAFDmH2dV+fbhFYKzfkuR3XlANHEmCBQ5h93dfRWwRyQ55fYORAC3AEARY4hNnXbRw92zpvWrOu69y4BRQjwAJVMfv6s6NnW+dNa6ZxBUoSYIFdmX19T6ktAt/NtmpagdoIsMCuzL6+p9QWAbOtQAQCLLArs6/LlN4ikGlcgQgEWKAKV599Lb1FINO4AhEIsMAuzL5+zxYBgM8JsMAuzL5+zxYBgM8JsMAurj77aosAwH4EWKCos86+2iIAsB8BFtjU1WZfa2laM40rcAUCLLCpq82+1tK0ZhpX4AoEWGBTZ5t9fdawZppWgOMJsEARUWZfnzWsmaYV4HgCLLCJaLOvr5rVbO+Gdc4WAYDXBFhgE9FmX181q9neDeucLQIArwmwwCZqm30tPbv6itlWgPcJsMChjpp9LT27+orZVoD3CbDAR46efa11dvUVs60A2xFggY8cPfta6+zqK2ZbAbYjwAIf2Xr2tfbZ1VfMtgLsT4AFDrF09rX22dVXzLYC7E+ABd6ydvb168f91J7W1rA+a1Sf0bQC7E+ABd6ydvY1P/5VEKytYX3WqD6jaQXYnwALvGXp7Ov88bV51bBqVAHqI8ACl/aqYdWoAtRHgAV+9GwrwNrZ16MtnV3VsALEI8ACP3q2FaC2WdW5pbOrGlaAeARYuLioe1fNrgJclwALFxd176rZVYDrEmDhYuaNa20Nq9lVAF4RYOFi5o1rbQ2r2VUAXhFg4aR+2h5QsnE1uwrApwRYOKlatweYXQXgUwIsBFdb06phBWBvAiwEV1vTqmEFYG8CLARRW9M6l4Pp7XbTsAKwKwEWgqitaZ3LzevtdtOwArArARYqU6ppnc+uvrqh67uP77pO8wrA7gRYqEyppnU+uzoMw483dAFAKQIsFFJ6pnXeuObtAG3brgrK+cfpuu7l7VkAsAUBFgopPdM6b1xzEM3n6vt+0TnMvgJwNAEWdlZb05o928c6TVMahmHxucy+AnA0ARZ2VlvTmtnHCkBUAixsJFrTOpfPPwzDos0DZl8BKEWAhY1Eb1rNvgIQhQALH8oBte/7EE3rM2ZfAYhCgIUPrW0uP2WmFYCrE2DhQ2uby6X2alrnzL4CEI0AC5U6qmk1+wpANAIsvGltc/nMUU3rM2ZfAYhGgIU3bTX7aqYVANYRYOFN7zSXJZvWObOvAEQlwMJBamtazb4CEJUACyu921zebrciTeszZl8BiEqAhZU0lwBQlgALKy1tLmtuXs2+AhCZAAs7qbV51SADEJ0ACwu901zWODNq9hWA6ARYWGirva8AwGcEWHghN69936e+7xfPvtY2M2r2FYCzEGDhhbPMjJ7l6wAAARZeOMvM6Fm+DgD4W+kDAADAGhpYeOIsM6Nn+ToAIBNg4YmzzIye5esAgEyAhSei37iVmX0F4GwEWPiQxhIAjiXAwsyZbtwy+wrAGQmwMHOWG7fMvgJwVgIs/GntjVu1O8sMLwDMCbDwp7M0r2tpXgGIRoCFP619t/7843KTWXp+9CwzvADwjJu44EO5uX08HlU0t7WdBwC2poGFP+UmMjeYS9rLlP63gU0p/f4r+JJN7NrZV1sHAIhGAwt/yrOg9/v9rVnQaM3np18vAJSigYU/5QY2pf+E0dxKLm1kSzexZl8BuAoBFmZyM5lD4DAM6fF4LH5zV25ix3FM9/v9sIB41S0KAFyPAAszX5vY/O85EL7TxObH772lwOwrAFchwMILuZFt2/atJjaHxK7rDm1kn7H3FYDoBFh4YT4bm/93TROb/32P2VizrwBcjS0EsFCtWwqibT8AgE9pYGGhd5vYbK8tBWZfAbgaDSysVGsT+4q9rwCchQYWVqqliTX7CsBVaWDhTaWbWLOvAFyVBhbeVPrmLrOvAFyVAAsfqv3mLntfATgbARY+dPTNXWZfAbg6ARY2tvfNXflxfd+bfQXgkgRY2NjeN3eZfQXg6mwhgJ2U3lJg7ysAZ6WBhZ1svS/265vEzL4CV7B0q8vWnr0HgXoIsLCzd2dis/lsbP6GDnB2+fvf2u+bn3r2HgTqIcDCzrZsYpd+PrOvEEOphjGKYRhS3/eHB9j8HoSz/bq8apa/FiS1N9B//Pr169+lDwFXkL8x9H2/a6OQm4O897Xmb0BwdWv3Rl+NEYJtvWqW8/MxpVR9A62BhYN8enPX2s9T8zceeOUqzWSphpGfrf2bryheNcv5+ZhSWtRAlwz6Aiwc7NObu+AKSs0+Hs1MO0eav6di7uvz8afHZSVnhQVYONinN3e9Mm8OzvpXYcS0tFnVTML21jTLSx63dlZ4yz+PzMBCYVvPxs6/QXg3LTVZ+jcOVxkhgMjWBtIt/zzSwEJhn24pmHt2o1f+8TSybGlt0NSswnmsnRV+dsPkOzSwUIm9thRoZNnT2hluzSpcV/7z6Ha7ffznkAYWKpGb2GmaNm1HNbKsoVGlJqW+P3mhtY/851HTNB//3AqwcDHzd6FqZPlq7bv/vYuePeWtLUd/f7Idpn4CLFyMRvZaNKp18/vtZ13XpdvtdniAzdthzvbrcqZmWYCFi9PInptGtW6lGsYocsA/2nxf91mcqVkWYKESOTgMw7Dom+bXb+y2FlzH1RrVsz//SjWM/Gy+r/sstm6W134/yr+fu677+AwCLFQiN2V93y9qwHJDkFLa9BW1RrZuV2tUz95QlmoYuaatm+W1jW7+/Lfb7ePnvQALhX1dn7WkKfu6huR2u6WU0l9eUX864/SqkZ2f46zN2FE0qj/TUMJ2tm6Wlza6+ftc/vwuMoATeLd5/foK9usr6q1nnJ7dna2Z3YZG9WcaSqjX0kY3/7m0JQEWCsuN59IA890r2K///OwV8bvN7LObVszKfk+j+jONKpzH0kY3/7mU/3kLAiyczLNXxHs3sxrZ/9Co/kyjCtfz9T0bW/3+F2ChkHe3Drx69+azV8TzZnbvWdmzNLIa1Z9pVIFX9tjq8MevX7/+vemPCCySG9E8+/oqIOWGM8++rg2G8yC2dSM7Dz5naWTX/jxFXxS+9tftLC9UgFg0sHCwT7cOvBsI56+Ar9rIalR/plEFItDAwsGObl6fuWojq1H9WS0vNAB+ooGFg22xdWALpRvZr5/3k8CkUf2ZRhU4IwEWSCn99/aCKPtkvev/Z971D5yRAAsH2WvrwFZeNbLZ3vtk19KoAlyPGVg4SC2zr0s9C6p7z8quZUYV4Ho0sLCzUlsHPlVqn2x0GlWA/QmwsLM8o5mb11fyjGNuXmuz96xsdGZUAfYnwMLOatk6sJXvmtkz/3W2RhWgPgIswA80qgD1EWBhJ7VvHXjXdxcgRHoDlUYVID4BFnZyttnXbL53NdpeVY0qQHwCLGws6taBuZ/WaEXYu/qsadWoAsQnwMLGztK8PrvhKkrj+qxp1agCxCfAwsaibR2I3rQu5QIAgPMQYOHiojetz+SvKwfWtTdeAVAvARY2UvvWgVJN67vN59Y3fE3TlNq2/f3jaWQB4hJgYSO1z76WalrXvus/2/qGL40swHkIsPChWrcOfLevtUTT+u67/pumSeM4/v7xNLIAZH/8+vXr36UPAZHlpjA3r68CVm7+cvO6V2CaN5ifBsBXnjWaW40QbN3Izs+lkQWIQwMLHyq9deDo2daj9qvmn6ev/35kI/v182pmAeoiwEJwR8+2ltqvmj/vXo3sfEY208wC1EeAhTcdvXWgli0CpW6yetXIZu82s/NG9ut/NysLUBczsPCmo2dfnzWOR8+21hLgfgr0ZmUBzk0DCyvtvXWglqY1K9W4vjJvZL/+d7OyAOemgYWV9m5ea2las2jB7OjtBZlmFuA4GlhYaeutA9H3tdbm6O0FX/+7WVmAYwiwUNh8i0Cpm7H23iJQyt7bCzI3fQEcR4CFhT7dOnDWfa2127uRzczKAhzHDCws9Ons66t9rVvPtp5lpnVre8/IZmZlAfajgYUX1m4d+O7j88zsFfa11m7vfbJfP37JrOzXc1z5hQXAGhpYeGFt85rNA8lV97XW7qh9splmFuBzGlh4Ye3WgfnHbc1s67aO2ieb2WIA8DkBFoK52haBUo7aXpDZYgCwnAALT6zdOrA1TWtZR83Kfv1xbDEAWMYMLDzx7uzrVmwRqItZWYB6aGBh5tOtA++yRaBuS2dlM1sMAPajgYWZUs2rLQIxaWYBjqeB5bKOvhkrM9t6LrVsMcj/H8AVCLBc1qubsfZii8A1HL3FAOBKBFgu47srRDWt7OXoLQYAVyLAchnzxlXTypHmjWymmQVYT4DldI6ebdW0ssRes7L5+dd1nTf8AZchwHI6R8+2alr5xKezsvnjb7eb5xtwGQIsYdWyRUDTyic+nZXNH+/5B1yJAEtYtWwR0LSyJbOyAK8JsFSvVNM6l4Pq7XbTuLKbtTd+mX0FrkiApXqlmtY5s4aU9KyZ9TcAwBUJsFTn6H2tr2heqcGzZhbgigRYqnP0vtZXNK8AUBcBlsO92nNZunGd8y5vAKiLAMvhns20ZqUbVwCgbgIsuys10zrf1+qGIwA4BwGW3ZWaaZ3va3XDEQCcgwDLbnJQ7fv+0JuxsnxDVtu2qwKzrQMAUDcBlt3k5rXv+0NvxspyEF17Ds0rANRNgGVzezWvr5rWeYB99xy2DgBA3QRYNrdX8/qqaT3qHABAWQIsH9try8C8cX3WtD47zzvNq60DAFA/AZaP7bVlYN64Lr3z/d3m1ewrAMQgwPK2rWZd1862bn0eWwcAIBYBlrdtNWO6drZ16/NoXgEgFgGWxbaadX13tvXVuTSvAHANAiyLbTXr+u5s66tzaV4B4BoEWJ7aervA1o2n5hUArkmA5amttwts3XhqXgHgmgRY/ste2wU+nXX99HyaVwA4BwGW/7LXdoFPZ10/PZ/mFQDOQYCl+lnX+Tk1rwBwbQIs1c+6ZppXACAlAfbSap91/fScmlcAOCcB9sJqn3XNNK8AwFcC7IXUepPWq/NqXgGArwTYC6n1Jq1nNK8AwHcE2AvYetZ172ZT8woA/ESAvYCtZ133bjY1rwDATwTYE4o265ppXgGAJQTYE4o265ppXgGAJQTYE4hyk9bTtqE4AAAFmklEQVQzmlcAYA0B9gSi3KT1jOYVAFhDgA0syk1az2heAYB3CLCBRblJ6xnNKwDwDgE2kOizrpnmFQD4hAAbSPRZ10zzCgB8QoANIPqsa6Z5BQC2IMAGEH3WNdO8AgBbEGArFPUmrWc0rwDAlgTYCkW9SesZzSsAsCUBtgJn2S4wp3kFAPYgwFbgLNsF5jSvAMAeBNiCzrJdYE7zCgDsSYAt6CzbBeY0rwDAngTYgqZpSsMwhJ91zTSvAMARBNjAamssNa8AwBEE2EBqnXV9d3uC5hUAeIcAG0its67vbk/QvAIA7xBgA6ilqdz6hrDSXw8AEJMAG0AtTeXWN4SV/noAgJgE2ACapkld1x3eVG59Q1hW6usBAM5BgOWprW8IAwDYggDLb3s1rlmefe267vcmBQCAtQRYftu7cTX7CgBsQYC9sD1nXHNAzQHY1gEAYCsC7IXt1bjmpjWllB6PR0opaV4BgM0IsBeyd+M6vyEspf9tYDWvAMBWBNgL2btx/e6GsNzEal4BgK0IsAXk4DgMw+829NXjh2H4r6Zz6ec5qnH9rmHVugIAWxNgC8hNaN/3ixrQ/PhxHP/SdC79uCMbVwCAvQmwBeRGdWkTmh+f0n/C47y1nb/rv2TjCgCwNwE2kNyozkcIuq77y7v+Na4AwJkJsIF8bWLn/z0HSo0rAHB2AuwJ5GY2//OnNK4AQM0E2BN41swupXEFACIRYNG4AgChCLAFNE3zbbs539u65+fXuAIAUf3x69evf5c+xNU8C6rDMPxli8Be8taCeeO69IIEAICSNLAFPGtgm6ZJ4zj+V5D8tJnVuAIAZ6KBrchezazGFQA4Ew1sRbZuZnNQvd1uGlcA4DQ0sAG828zm5vV2u2lcAYDT0MAGsLaZzcy6AgBnpIENbOkIgeYVADgTARYAgFD+VvoAAACwhgALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhCLAAgAQigALAEAoAiwAAKEIsAAAhPL/AQ1kkZwbSfKoAAAAAElFTkSuQmCC
Le type text est considéré comme obsolète depuis la version 2005... cela fait maintenant 15 ans !!!!!!
Il serait peut être temps de lire la doc :
Pièce jointe 531051
Oups!! ;-)
Ça fait longtemps que je ne lis plus les docs... ;-)
C'est une ancienne base SQL Server 2000 que je viens de migrer....donc évidement le type "text" j'avais zappé!
Merci pour le tuyau.
varchar(MAX) fonctionne très bien.
