Re: SP

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 06/05/04 

Date: Fri, 4 Jun 2004 22:31:04 -0500

You can create multiple objects with the same name in the same database as
long as the owner (schema) is different. Also, you can create 'numbered'
procs, each with the same owner and name but different numbers. In my
experience, the use of numbered procs is not common. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Ramesh" <ramesh@mail.punecity.com> wrote in message
news:%23g%23HMsqSEHA.3944@tk2msftngp13.phx.gbl...
> Hii All
> my question may sound really stupid ...Can we create stored
> procedures/Tables with the same name in the same database??i was asked
this
> questn in a recent interview and my asnwer was obvsly no.but that guy was
> very firm on his answer that its possible.. is it actly possble???
> Reply to newsgroup only...
> Ramesh
>
>

Relevant Pages

  • Re: cross chema calls fail: schema owner doesnt have execute priv
    ... Doesn't changing the owner to dbo defeat the purpose of having the schema? ... What about CREATE PROCEDURE WITH EXECUTE AS OWNER? ... Then I created a bunch of stored procs under this schema. ...
    (microsoft.public.sqlserver.security)
  • Re: Internet Explorer Scripts Error
    ... generation net will not longer be updated and will be ... removed by new owner. ... Henri Leboeuf ... Ramesh - Microsoft MVP ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Control over creation of procs & views owned by dbo
    ... to only create & drop stored procs and views in DevDB. ... extra permissions does the user need? ... the user create procs with him as owner. ... that would execute in the owners context and hence would ...
    (microsoft.public.sqlserver.security)
  • Controlling create & drop proc, view privilege
    ... to only create & drop stored procs and views in DevDB. ... extra permissions does the user need? ... the user create procs with him as owner. ... that would execute in the owners context and hence would ...
    (microsoft.public.sqlserver.security)
  • Re: Delete File
    ... Thanks Ramesh - will try those. ... owner of the "problem" computer to carry out your suggestions. ... > How to Remove Files with Reserved Names in Windows XP ...
    (microsoft.public.windowsxp.help_and_support)