How to resolve the error (Msg 4121) in SQL Server

Posted by Bandi under Sql Server on 7/16/2014 | Points: 10 | Views : 4571 | Status : [Member] [MVP] | Replies : 2
how to resolve the below error in SQL Server?

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.functionName", or the name is ambiguous.

One thing the same function is working fine in one application... But not working from another application...

the function which am trying to call is Scalar Valued Function. It returns only one value.
The schema name id dbo.

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif



Responses

Posted by: Sheonarayan on: 7/16/2014 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
It appears that you do not have enough permission to call the function. Check the username permission from which you are connecting to the database.

The other application that is able to call the function is using the same username to connect the database or different?

In all cases, it looks like permission issue. Also check if you are using two different version of the same database and in this database your function might not exists.

Hope this helps.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Bandi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 7/18/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
i don't think its permission issue...

we created views in the old database(DB1) to access new database (lets assume DB2) table's data. The old application working fine without these views. but the error message is not showing with any view name. In the views we are not using those functions which causing error.

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Bandi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response