Transact SQL – dbo.sp_MS_marksystemobject and casing


I am working on a stored procedure that returns metadata from SQL Server Object views.

And, though it will reside in the master database it needs to contextually run against the targeted database.

Unfortunately, the SQL Instance I am trying to deploy it against is a case-sensitive database and so everything has to be in its proper case.



Unfortunately, undocumented objects are not exposed in system catalog views and so there is no way to verify the actual case.


Trial & Error

Through trial and error, found it to be




exec [dbo].[sp_MS_marksystemobject] [object-name]


exec [dbo].[sp_MS_marksystemobject] 


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s