Can I give the same name to a table and a stored procedure? Is it possible to name a stored procedure the same as a table? I have an existing table named 'buyers', and I'm trying to create a stored procedure named 'buyers', but I'm getting this error:


  There is already an object named 'buyers' in the database.
No. This is clearly stated in the MSDN documentation:


  Procedure names must comply with the rules for identifiers and must be
  unique within the schema.


Since you have a table with the same name, in that schema, you cannot create the stored procedure with that name.