Bonjour,
Voici mon problème:
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.
Bonjour,
Voici mon problème:
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 +
Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
* * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *
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/4xzOilAORpYgIqs3UbgZi7giszAAgAQigALUKHcxHZdZ64VYEaABaiQm7kAnjMDC1AhN3MBPKeBBQAgFAEWAIBQBFgAAEIRYAEACEWABQAgFAEWAIBQBFgAAEIRYAEACEWABQAgFDdxAVRomqY0jmMahiFN01T6OABVEWABKjSOY3o8Hqnv+zSOY+njAFRFgAWo0DRNaRiGNAzDj49rmia1bZu6rktN0xx0OoCyBFiAwNq2Tff7Pd1ut9S2benjABxCgAUIrGma1HVd6rqu9FEADmMLAQAAoQiwAACEIsACABCKAAsAQCgCLAAAoQiwAIF93Rfrxi7gKgRYgMDyjV2PxNXcBlCLAAAITiIgOAwNzEBVyRAAsQmJu4gCsyQgAAQCgCLAAAoQiwAACEIsACABCKAAsAQCgCLAAAoQiwAACEYg8sQEWmaUrjOKZhGNI0TaWPA1AlARagIuM4psfjkfq+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+Hs1MO0eav6di7uvz8afHZSVnhQVYONinN3e9MmzvpXYcS0tFnVTML21jTLSx63dlZ4yz+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 :
Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
* * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *
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.
Vous avez un bloqueur de publicités installé.
Le Club Developpez.com n'affiche que des publicités IT, discrètes et non intrusives.
Afin que nous puissions continuer à vous fournir gratuitement du contenu de qualité, merci de nous soutenir en désactivant votre bloqueur de publicités sur Developpez.com.
Partager