Stored procedures problem

remus · Post by **remus** » Thu Oct 12, 2006 5:02 pm

Hi
We are having a problem when we try and exec a stored procedure.
Our stored procedures in the database have a naming convention like this "Notic.RptListCustomerInformation"
When we try and "exec" the stored procedure it can't find the stored procedure.

But when we name the stored procedure "dbo.RptListCustomerInformation"there is no problem.
We can't change the naming convention because it is tied into our business logic layers.
Is this something that is known about or are we doing something wrong?
Thanks
Philip

remus · Post by **remus** » Thu Oct 12, 2006 9:38 pm

Hi
Worked it out it was our Problem.
Thanks
Philip