Thank you so much for all the replies. I will try my best and let you know if I have any questions.

Thanks again

Thnaks for your reply. But I didn't get what that stored proc is doing and how it gonna fix my issue. Please explain.

Yes it is not returning what I expect. I want resultset of only the objects which are using RegulatoryType column in the where clause. But I am getting the objects...

DECLARE @SQL VARCHAR(MAX)

SET @SQL = ' USE ?; SELECT ''?'' AS DATABASE_NAME,

sys.schemas.name AS [Schema Name], sys.objects.name AS [Object Name] ,

type_desc...

I am trying to do with the above query whatever I have inserted in the block and it is partly working. But it is also getting the objects which are...

Actually I need a T-SQL Script for this. Please help me if you have any idea.

I am sorry for not responding to your post immediately. I dont want the image to be displayed on fly. I just dragged an image onto the header of my...

Thank you so much for your replies. I really appreciate it.

Yeah Thats weird. Thank You so much. I followed your code and I got it. Thank You

I am sorry for not communicating properly. I was in urgent need situation and couldnt give proper subject name.Sorry for the inconvinience. I am new to sql prigramming. I am...

Yes. I got it. Thank You so much.

Thanks a ton :)...I really appreciate your help. I have been struggling with this since 2 days.

No. The 'Application Group' is an extended property. I am checking first if the extended property 'Application group' exists or not. The value for this property is blank for some...

I have modified like this

IF NOT EXISTS(SELECT 1

FROM fn_listextendedproperty ('ApplicationGroup',

...

The script you provided

IF NOT EXISTS(SELECT 1

FROM fn_listextendedproperty ('ApplicationGroup',

...