Carla Wilson (10/7/2008)
Wow, good job investigating system tables/views and triggers! (although I did not expect you to drop everything to do it - - I was just reply to your question.)
Your testing is much appreciated.
Finished the 2005 attempt: fail with the following message:
Msg 8197, Level 16, State 6, Procedure tr_syscolumns, Line 1
Object '_syscolumns' does not exist or is invalid for this operation.
Got the same error before trying to slide past it with view.
It seems to me that it should be possible. I glanced at this article
here on SSC, so maybe it's possible, perhaps I just need to work at it a bit more.
-----Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson