I'm working on a project right now where we have a 'front page' application, and a web service at the backend - which is being called via Ajax. I am currently saving the authenticated user's information into the session so that I can track them through the site - but when calls are made to the web service, I need the session to be available to it, too.
I went through setting up session state storing using SQL Server, and found this blog post about modifying the stored procedure to retrieve the same session state for my two applications. However, when I attempt to run the SQL that he provides, I get these errors:
Msg 2715, Level 16, State 3, Procedure TempGetAppID, Line 2 Column, parameter, or variable #1: Cannot find data type tAppName. Parameter or variable '@appName' has an invalid data type. Msg 2715, Level 16, State 3, Procedure TempGetAppID, Line 2 Column, parameter, or variable #3: Cannot find data type tAppName. Parameter or variable '@dupApp' has an invalid data type.
However, I can't figure out what I need to change to make the query run.
Does anyone know what I need to do to create the tAppName data type, or what I need to change the type to?