Post reply

How to check the size

  • April 14, 2011 at 9:02 am

    #389286

    Hi

    I am having a table "Mesages" in a database.One of its column name is "mesagesize" which indicates the size of the message.it is showing 56789.How can i determine whether it is in MB or Kb.The data type used is int.

  • April 14, 2011 at 9:04 am

    #1311678

    You would need to check the application that is inserting/updating the table.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • April 14, 2011 at 9:13 am

    #1311685

    the application is outlook..how can i check that

  • April 14, 2011 at 10:49 am

    #1311732

    Have you attempted to use the DATALENGTH function on the message field of that DB table?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • April 15, 2011 at 12:22 am

    #1311946

    If that are MB, than message size would be 56 GB, which is very unlikely.

    So, the size is either KB or bytes.

    You can find a message in your outlook and see it's size in outlook,

    then find the same message in this table and compare the numbers.

    You will probably find that size is in bytes.

    If you have message text stored in the that table, "select datalength(messagetext) from messages" would also help - it gives bytes.

    Regards,

    Vedran

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

Viewing 5 posts - 1 through 4 (of 4 total)

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