Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajesha
Starting Member
36 Posts |
 Posted - 2002-06-07 : 05:59:54
|
| in my application am using asp in the front end with ado.i have created a a user defined function uf_calculate with owner dboquery is insert into travel.dbo.claim (price) values(travel.dbo.uf_calculate(ticket_value))but when am running the query through an asp page it is showing an errorError Type:Microsoft OLE DB Provider for SQL Server (0x80040E09)EXECUTE permission denied on object 'uf_calculate', database 'travel', owner 'dbo'but this query is running in sql query analyser.not from the page while callingwhat is the problem... |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-06-07 : 06:51:46
|
| Hi!Works for me... Are you using the same user when trying it in the SQL analyzer and via ASP?? Check out the permissions on the function. |
 |
|
|
rajesha
Starting Member
36 Posts |
Posted - 2002-06-07 : 07:22:08
|
| thank you...i checked permission...now it is working... |
|
|
|
|
|
|
how to call user defined function in asp