Do I need the "dbo" at the end of my stored procedures?

[mistux]

I have some stored procedures with (dbo) after them and some that don't. Do I need this? how do I get rid of it? Do I need to refernence them in my code?

I intend to send my Access 2000 ADP front end to a customer and the back end SQL to them is this naming convention going to cause me issues?

Thanks, Mitch

 

[tcsbiz]

I don't think it will cause any problems.
having dbo in the name identifies it as a database object. It is for human readability only.

The customer may be expecting you to follow their naming conventions, though.