Re: create a global procedure

From: David Browne (meat_at_hotmail.com)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 10:52:44 -0600

"Adam Machanic" <amachanic@air-worldwide.nospamallowed.com> wrote in message
news:OkZqutcDEHA.2628@TK2MSFTNGP11.phx.gbl...
> If you don't qualify by owner you will force more scans of the procedure
> cache. Turn on Profiler and watch for the SP:CacheMiss event, then
qualify
> by owner and watch it disappear...
>

I have no real problem with prepending "dbo." to every object name. Just
all objects should be owned by DBO and never refered to with the database
name (unless they actually reside in another database, of course).

David

Relevant Pages

  • Re: Newbie to T-SQL
    ... You have to qualify your tables with the database name and the owner: ... INNER JOIN db2.dbo.table2 t2 ...
    (microsoft.public.sqlserver.server)
  • Re: montresallison
    ... Anyone who posts here regularly knows about the issues with MA, the crap it sells and the shady, criminal past of its owner, and it surprises me that you all would feed the troll like you have. ... The first MA watches were not finely finished and had high retail ... The owner used to own a watch forum called watchzone.net and got into ...
    (alt.horology)
  • Re: object reference in stoed proc
    ... If you don't qualify the object sql server will first look for the object ... as such it will eventually try dbo. ... implications by not qualifying the objects with the owner. ... all object refences dbo by default anyway within a stored procedure? ...
    (microsoft.public.sqlserver.security)
  • Re: Boeing Machinists
    ... Your owner is off to watch a movie and get some sleep. ...
    (alt.machines.cnc)
  • Re: Toyota, So What
    ... What he might have meant was that if they adopted showroom stock ... THEN he'd be ready to watch the Bristol race. ... I heard a story about the track owner letting a NASCAR honcho ...
    (rec.autos.sport.nascar.moderated)