SMO uses sysobjects and sys.objects instead of INFORMATION_SCHEMA(weblogs.asp.net)

submitted by jongalloway(4380) 5 years, 4 months ago

Why? Who knows, but you can fix your scripts with a regex replace. read more...

add a comment |category: Database |Views: 14

tags: JonGalloway SMO SQL INFORMATION_SCHEMA another

Another Bulletproof SQL Script Using INFORMATION_SCHEMA Views(stevenharman.net)

submitted by ussherm(5285) 5 years, 10 months ago

This article presents a SQL Script that will use the INFORMATION_SCHEMA Views to determine if a particular Stored Procedure exists in a database for a given schema... and an optional script that makes use of Template Parameters. read more...

add a comment |category: Database |Views: 13

tags: StevenHarman INFORMATION_SCHEMA SQL another