July 15, 2009 at 12:55 pm
1)Can anyone please explain from where is the sys.configurations fetching the data from ???
2) What is the significance on catalog views in sql server 2005.
Thanks
July 15, 2009 at 1:08 pm
- sys.configurations is the source system object for sp_configure.
It is a system object, so where it gets it data from shouldn't matter.
(you can nolonger update catalog tables directly)
- AFAIK the catalog is made available to us using views, so MS has more liberty/flexability with the actual code behind (resourcefiles.mdf)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 15, 2009 at 2:18 pm
It's a way for your to consume system data from a view, instead of having to parse results from sp_configure.
July 20, 2009 at 4:42 am
SYS.CONFIGURATIONS Derive information from mssqlsystemresourcedatabase which is a hidden system databaase.
while we execute the code "select * from sys.configuration" sql server would fetch the data from this database.
July 20, 2009 at 5:00 am
MADHAN_PERS (7/20/2009)
SYS.CONFIGURATIONS Derive information from mssqlsystemresourcedatabase which is a hidden system databaase.
The definition of the sys.configurations view is in the resource DB, but the info that it retrieves is not. The definition of sys.configurations shows that clearly.
CREATE VIEW sys.configurations AS
SELECT < several columns &ft;
FROM OpenRowset(TABLE CFGPROP) p
LEFT JOIN master.sys.sysobjvalues v ON v.valclass = 50
AND v.objid = p.id
AND v.subobjid = 0
AND v.valnum = 0
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply