Re: Difficult qualified name problem

From: Stamey (Stamey@REMOVEThisAndTheDot.Farther.com)
Date: 11/27/02 

From: "Stamey" <Stamey@REMOVEThisAndTheDot.Farther.com>
Date: Tue, 26 Nov 2002 23:59:56 -0500

OK, I'll check it out some more and get back to you.
My address: Stamey AT removethis Farther.com

Chris

"Daniel Pratt" <kolREMOVETHISkata_is@hotmail.com> wrote in message
news:eVuyPRXlCHA.2116@tkmsftngp07...
> Hi Chris,
>
> "Stamey" <Stamey@REMOVEThisAndTheDot.Farther.com> wrote in message
> news:#kt19dQlCHA.1464@tkmsftngp07...
> > What version of SQL Server are you using? I tried this on SQL 2000
before
> I
> > posted the reply and it seemed to work fine. I just tried it on 7.0 (the
> 200
> > box isn't available right now) and it did not work, giving the results
you
> > describe.
> > There is another way, by modifying a System stored procedure or two, if
> you
> > want to do that.
> >
> > Chris
>
> We are running SQL Server 2000, as well. If I do the following...
>
> 1. Log in as "sa"
> 2. Create the MakeTable procedure (now owned by "dbo").
> 3. Grant EXEC permission to testuser
> 4. Log in as "testuser"
> 5. Execute the MakeTable procedure.
>
> ...the result is a new table in the database, TestTable, which is
owned
> by "testuser", which is a problem for reasons I've mentioned previously.
>
> Regards,
> Dan
>
>

Relevant Pages

  • Re: obtaining return values from DBCC INDEXDEFRAG in a sp
    ... Regards ... > the results from INDEXDEFRAG except using an external text file. ... > Dan - what do you want to do with the values, ... Microsoft SQL Server Storage Engine ...
    (microsoft.public.sqlserver.server)
  • Re: Error adding Distinct Count measure
    ... Chris is righ, it supposed to work with string. ... the collation on a cube (in the cube editor in BIDS, ... Microsoft SQL Server Enterprise Edition ...
    (microsoft.public.sqlserver.olap)
  • Re[2]: Visual Query Builder
    ... Or we can mail fix to you by ... C> so I have confined testing to SQL Server and Northwind. ... C> to use the older fashioned joining in the where clause) so I am not quite ... C> Chris ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How do you store a 20+ digit integer?
    ... I must have have comletely blanked on that datatype and forgot all about it...it's been one of those weeks... ... Chris ... Columnist, SQL Server Professional ... I have come across a situation where I need to store 20+ digit integers ...
    (microsoft.public.sqlserver.server)
  • Re: Installing Stored Proceedures
    ... Kalen Delaney ... "Chris Welbourne" wrote in ... Well done on the Inside SQL Server 2000 Book, ... it is strange to say 'installing' a stored procedure. ...
    (microsoft.public.sqlserver.server)
Loading