May 31, 2012 at 9:00 am
I am getting different results for two queries about a table column.
when I run the following query against syscolumns:
Select so.name,so.xtype ,sc.name,sc.xtype from sysobjects so
Join syscolumns sc on sc.id = so.id
Where so.name = 'abn_'
And sc.name = 'person_id'
I get no rows
when I run
select * from information_schema.columns
where table_name = 'abn_'
and column_name = 'person_id'
I get the row for abn_.person_id
Do I have a corrupt database? And how can I fix it?
May 31, 2012 at 9:09 am
Not being ale to look at what is in your system, not sure. One thing I would suggest, however, is to not use sysobjects and syscolumns. These are for backward compatibility. You should start using the new system views; sys.objects, sys.tables, sys.columns, etc.
May 31, 2012 at 9:12 am
I'm not sure what would cause that but if you want to see if you have a corrupt DB run dbcc checkdb.
May 31, 2012 at 9:13 am
it runs fine on my SS2012 and SS2008R2 dev databases. It just doesn't run on production.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy