I guess this [^]will help you. I Love T-SQL "Don't torture yourself,let the life to do it for you."

Ri Qen-Sin wrote: Ironically, you seem to be getting 2's on average. ya although there were many posters trying to help me out with 5 votes!! I think there's more than one univoter here around in CP.. gotto figure them out some how!!! :sigh: :mad: Sathy

'IsMSShipped' means "Object created during installation of SQL Server 2005". Possible output is 1 - True, 0 - False. For more information see the SQL Server 2005 BOL. :)

DigiOz Multimedia wrote: Make sure your application is market to run as an application (not a simple folder). Checked. DigiOz Multimedia wrote: Check web.config file for any unusual keys or configuration setting No unusual keys. DigiOz Multimedia wrote: Check to make sure IIS is running the correct version of .NET, i.e. if your application is ASP.NET 2.0, make sure your IIS is not running 1.1 or 1.0. Both my application and IIS are running under ASP .NET 2.0 DigiOz Multimedia wrote: Make sure that the user under which your ASP.NET is running has read and execute permission to your application folder If this is the case then all the other pages in the site was working perfectly at the time when i was getting the 'runtime error' in clicking the hyper link for few pages. Sathy

Albert Pascual wrote: you need to pass the System.Web.HttpContext.Current to work No, you dont as this is essentially a Singleton instance that can be accessed from anywhere. In a class file: System.Web.HttpContext.Current.Session["MySession"] = "Something" Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour

:doh: thanx a lot for the idea... mate sathy

imsathy wrote: i want to call a sql function thro webservice is thier a way to do tht Calling into a database is a function of ADO.NET. It doesn't matter whether it is a web forms application, a console application, and Win forms application, a windows service, a web service or what ever. imsathy wrote: i tried call it like a stored proc but it didnt work That's a little vague on detail. How exactly didn't it work? ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Glad you sorted that out. Have a good day, Paul

:)thanx a lot Colin sathy

thanx a lot Guffa..... the error was bcoz i was callin the function inside the script and not on the onload event of the page :)..... sathy

found that out its window.showModalDialog();;) sathy

thankzzzz a lot Masqood:cool: superb!!!! sathy

Thanks a lot Robert:cool: "(" this is bcoz i edited the code here its the third point is wat i missed out..... GREAT!!!!!!! sathy

thanks GV, but this is how i made the setup but this is installing and i can c my service at the windows service list but i cant start it ... its showing a "JIT error " sathy