Hi all, I have a strange problem which i will explain below. I have a web page which pulls back data from a table using a Stored Procedure. The Stored procedure works as expected when opened up in the database, but when i call the Stored Procedure from the web page three particular columns are missing (all appear to be text columns). I have also created a dummy text column, thinking it was that data type at fault, this column works in the web page. Is there anything I could do or try to correct this problem? Cheers all.
There is no issue like calling SP in QA fires perfectly and while calling it from web page column misses. There is something wrong coded about recordset returned to web page. Just debug the code to verify the columns sent.
Can you post query of that SP in order to debug. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
