Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swilliams
Starting Member
1 Post |
 Posted - 2013-05-13 : 18:58:24
|
| 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
52326 Posts |
Posted - 2013-05-14 : 00:59:17
|
| 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 belowsp_helptext 'ViewName'and check if view definition contains all of your expected columns------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
data was displaying now all of a sudden it's not