Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    7

    Unanswered: sql variant data type corruption

    I have a user who uses the sql variant data type. Currently the database he uses is read only and he has noticed a lot of "garbage" in the column in the last few days. A dbcc shows no corruption and the user is following the rules of the sql variant data type as far as we know.
    One last thing, he never had this problem on AS 2000.

    config:
    SQL 2000 SP3 on Windows Server 2003

  2. #2
    Join Date
    May 2004
    Posts
    7
    The problem seems to result from DTSing the SQL variant datatype. Has anyone heard of this ?

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No, but I guess it does not surprise me that there could be miscommunication between applications or utilities when exchanging the SQL Variant data type. I would avoid using it except for certain functions or procedures that might need to act on unknown datatypes. The fact that you have it built into your business logic makes me suspicious of your design. You certainly do NOT want to use it as a "default" datatype for all your columns.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •