Has anyone kept this alive? This was a great utility.

Doug

I would switch the temp table to be

CREATE TABLE #invalid_db_objects 
(
 ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
 invalid_object_id INT NOT NULL, 
 invalid_obj_name NVARCHAR(1000) NOT NULL,...

• This reply was modified 1 year, 9 months ago by  SQLOzzie.

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...