Thursday, December 6, 2012

Search special colum name in all databases on SQL Server

sp_msforeachdb
'select "?" AS db, object_name(object_id,db_id("?")) , * from [?].sys.columns
where name=''user_login_name'''