Post reply

Union Selects and Auditing of Text Fields

  • September 14, 2006 at 8:55 am

    #115347

    Hi All (SQL Server 2000)

    I need to allow the user to store up to 5 fields of almost unlimited length (greater than 8000 chars) in a db table. I need to be able to do union selects with them in SPs without casting to varchar(8000) otherwise I may potentially truncate the data.

    I also need to be able to do auditing of the table from triggers using the Delete and Insert system tables.

    Can someone give me some suggestions.

    Thanks

    CCB

  • September 14, 2006 at 11:30 am

    #660477

    As you probably already know you can't have varchar columns of more that 8000 therefore in SQL Server 2000 your only option is "text" datatype. To audit those from Triggers you will need to use "INSTEAD OF" Triggers because text data type is not available for normal triggers


    * Noel

  • September 15, 2006 at 1:36 am

    #660604

    Thanks Noel for the trigger info.

    How about Union Selects - any suggestions on how I can get around this with text data types?

    CCB

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

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