I've been a user on SQL Server 2005 for several years now (no experience on prior versions), and just starting to explore some of the under the hood stuff. I recently started looking at the various system views and I have some questions... so much to learn.
For example, I got curious about how sys.database gets its information. So I did sp_helptext 'sys.databases' and it showed me the view definition. Looking at it, I see that the 'name' column of the view comes from master.sys.sysdbreg. But I can't seem
to find this object anywhere in master. In fact, if I try to run the select statement that defines the view, I get an error that says,
'sysconv' is not a recognized built-in function name.
And if I resolve that error, I seem to get more errors? Am I trying to dig too deep?
View Complete Post