dlsilsbury 63952 (5/28/2015)
Eric M Russell (5/27/2015)
No. System views are those distributed with SQL Server. There is rarely a reason to mark a user created object as 'system'.
Thanks, I understand this but I was just curious how?
There is an undocumented stored procedure called 'sp_ms_marksystemobject' which can be used to mark stored procedures as system. This is done when someone writes a general procedure for cross-database operations. Also the procedure is typically deployed in MASTER database. This might also work for views and other objects, but I don't know. I found an article where someone did a write up on how to use sp_ms_marksystemobject.
http://raresql.com/tag/sp_ms_marksystemobject/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho