SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 data was displaying now all of a sudden it's not
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

swilliams
Starting Member

USA
1 Posts

Posted - 05/13/2013 :  18:58:24  Show Profile  Reply with Quote
I am querying a record from SQL Server 2008 and all the data has been showing up just fine. Now all of a sudden there are just a few of the record fields showing up. For the ones that aren't showing up I've confirmed that the data is still in the database. I haven't made any changes to the script. I have no idea why just 3 of the fields would just stop displaying. Any help would be appreciated. thanks

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 05/14/2013 :  00:59:17  Show Profile  Reply with Quote
Where you querying record from a view? If yes, it may be that someone might have altered the view to exclude the other column.
You can try the below

sp_helptext 'ViewName'

and
check if view definition contains all of your expected columns

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000