Home Forums SQL Server 2008 T-SQL (SS2K8) Information_Schema.Columns on All Database RE: Information_Schema.Columns on All Database
Ant-Green
SSC Guru
Points: 113445
More actions
November 6, 2012 at 12:56 am
#1556337
sp_msforeachdb also doesnt take into account certain characters in the DB Name, so it wont work as intended if such characters exist. The methods advised of going through sys.databases and using Quotename gets around this issue.