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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Sql server 2000 error

Author  Topic 

tosinf
Starting Member

1 Post

Posted - 2009-03-03 : 11:02:50
I'm working on a project currently. Any time my application gets to where it is meant to insert, i get this error: "Invalid object dbo.customerNumber". CustomerNumber was a udf but has since been deleted. Have searched the code and sql but nothing like customerNumber was found. Please...... Help...... It's very urgent.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-03-03 : 11:58:10
moved to proper forum.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-03 : 12:38:12
it means you're trying to access a non existent udf which causes this error. are you using inline query? if yes, search for presence of dbo.customerNumberinside your application
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2009-03-03 : 17:18:18
Possibly imbedded in a trigger on the table you're try to insert into?

Terry

-- Procrastinate now!
Go to Top of Page
   

- Advertisement -