Post reply

does SQL 2005 solve the 8 Meg Blob Limit for DTS?

  • September 29, 2004 at 7:51 pm

    #162292

    We recently had a problem with DTS on SQL 2000 where there is limit of 8 Meg for blobs with DTS, this is from 64KB with SQL 7 but I am wondering if it is greater yet again with SQL 2005?

     

    Regards

    Drew

  • October 1, 2004 at 12:26 am

    #524975

    I dont understand your question clearly I suppose. Generally when we talk about blobs in SQL, its a 2GB limitation. And if you are mentioning this, then nothing much has changed for SQL2005. If not then please do give us more explanation to the problem.

    Vinod Kumar

  • October 1, 2004 at 7:42 am

    #525019

    if you are using a DTS package in SQL to copy a database, the SQL DTS engine apparently has a limit of on the BLOB size it can handle. In SQL 7 this is 64 KB, in SQL 2000 this is 8 MB. Does anyone know what the limit is in SQL 2005.

    see KB 257425 for the issue

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply