We have unique dilemma at hand. Two SQL Server 2k5 functions are giving different results;
SP_Columns and Information_Schema.Columns
What could be the reason and how to resolve it? And I thought I was adept with SQL Server! :-D
Submitted by Atif Fasihi
Subscribe to:
Post Comments (Atom)
Posts
1 comment:
I think there is some Meta data synchronization problem in SQL Server because sp_columns and information_schema.columns get information from different sources.
check:
sp_helptext "information_schema.columns"
sp_helptext "sp_columns"
Post a Comment