Mircrosoft provide a simple stored procedure that will give you result, a thousand line of t-sql code can do.
Simple run this against any database and you will get the result.
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
661 reads