Unanswered: Issue with views in sql server 2005 express
Hope you are all doing well!
To get down to my problem, I am using sql server 2005 EXPRESS with classic ASP. When I run a SELECT statement in the SQL server management studio it retrieves correct data from this view in question. But when I run the same query through ASP it doesn't retrieve any kind of data for one nvarchar(MAX) type field although it returns data for other fields.
But it all works fine when I use sql server 2005.
Please help. Thanks in advance.