Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daidaluus
Yak Posting Veteran
73 Posts |
 Posted - 2014-01-27 : 07:15:17
|
| Is there a way to see the definition of system views or functions in master db like sys.sql_expression_dependencies or sys.dm_sql_referenced_entities? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-27 : 07:34:28
|
yesEXEC sp_helptext 'sys.sql_expression_dependencies'... ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
daidaluus
Yak Posting Veteran
73 Posts |
Posted - 2014-01-27 : 07:43:31
|
| Thank you for your reply.I came from SQLServer 2000. In that we had all objects in sysobects and all texts in syscomments. but I dont see any entry in sys.objects or any definition in sys.sql_modules. is there a way to query the name of these objects? something like SELECT * FROM sys.XYZ WHERE name = 'sql_expression_dependencies' |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-27 : 07:51:26
|
quote:
Originally posted by daidaluus
Thank you for your reply.I came from SQLServer 2000. In that we had all objects in sysobects and all texts in syscomments. but I dont see any entry in sys.objects or any definition in sys.sql_modules. is there a way to query the name of these objects? something like SELECT * FROM sys.XYZ WHERE name = 'sql_expression_dependencies'
sorry didnt understand whats the issue with method i posted in earlier thread------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
daidaluus
Yak Posting Veteran
73 Posts |
Posted - 2014-01-27 : 07:56:27
|
| nothing wrong with your solution. it solved my problem and thanks for it.what i say is that why , like SQL2000, these system objects dont have any entry in a table like sys.objects? or at least i cant find any. |
|
|
|
|
|
|
system views definition