Transact SQL – dbo.sp_MS_marksystemobject and casing

Background

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.

 

Undocumented

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

sp_MS_marksystemobject

Usage

Syntax


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

Sample


exec [dbo].[sp_MS_marksystemobject] 
      '[dbo].[sp_IndexIdentifyDuplicatesIgnoreIncludedColumns]'

go

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s