How do you check which columns is update using columns_update()

[blueyeboyz]

How do you check which columns is update using columns_update() if the columns have more than 32 columns??

thanks,
bluei

 

[tlbroadbent]

Knowledgebase article 232195 states, "Since the bitwise operator only works on 32-bit integers, you may have difficulty checking a table with more than 32 columns."

http://support.microsoft.com/default.aspx?kbid=232195

Never tried it myself and most news group postings indicate, columns_update() cannot be used for more than 32 columns. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm