Modified to add schema and to use sys.Tables

CREATE proc [dbo].[usp_DBDetailsRevised]

AS

SET NOCOUNT ON

DECLARE @id INT, @cnt INT

DECLARE @FullName...