chauchs (7/9/2013)
Is there a way to edit the system functions?
Nope. The ability to mess with system objects was taken away in SQL 2005 because people were modifying the system in unsupported ways, getting wrong behavior, and then calling Microsoft in to help them fix their system. That's when the System/Catalog Views and DMOs were introduced.
As the system procedures in the database mssqlsystemresource, because I can see them but can't generate script !!
I would like to know where the functions (like SUSER_SID, SUSER_SNAME ...) get information.
That stuff is likely buried in a DLL compiled from C++ code, so no again.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato