October 21, 2011 at 12:10 pm
I had some functions that were not recognized in SQL2008 post upgrade. Compatibility was set to 90 (2005) then functions were recognized. DBA was asked to change compatibility back to 2008 and functions were recognized. Developer and DBA are puzzeld by the fact that nothing was changed in code, functions etc.. prior to switching compatibiity back 100 (SQL2008).
Anyone experienced this???
App is on .net platform 2005.
Thanks to anyone who might have input...
October 21, 2011 at 1:08 pm
We need more information to determine what happened. Based on the information you have given, my suspicion would be that there was nothing wrong with the functions to begin with, but perhaps they were called in a different way like not qualifying schemaname or something like that.... but before we start taking guesses, we more info.
What do you mean exactly by "not recognized"- can you post an error message you received when initially trying to use the functions in 2008 compatabilty mode?
October 21, 2011 at 1:27 pm
Actually no error message displayed. The function called from stored procedure was not fetching data from database to display on page for end user-this was only occurring for dates stored in one table while dates dates fetched from same function but from a view (given condition was met) worked just fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply