Post reply

QOD 10-22

  • October 21, 2003 at 8:40 pm

    #106533

    I like questions where I know the answer right away. Makes me feel smart

    Data: Easy to spill, hard to clean up!

  • October 22, 2003 at 2:59 am

    #479046

    Yeh pat yourself on the back, sycophants united. No one likes a smart a$$

    Besides, the higher your pedestal the further you fall.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 22, 2003 at 4:24 am

    #479054

    I hope this will stay bilateral !

    Btw, thanks David for the word 'sycophants'. Guess, I will use this internally frequently from now on

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 22, 2003 at 6:18 am

    #479073

    The "correct" answer seems incomplete to me. After creating the sp the developer would also need to grant access to other users. As the question does not say that happened the "correct" answer would result in a permission denied message, not access to the object.

    Ross Hamilton

    DBA


    Ross Hamilton
    DBA

  • October 22, 2003 at 7:34 am

    #479093

    quote:

    The "correct" answer seems incomplete to me. After creating the sp the developer would also need to grant access to other users. As the question does not say that happened the "correct" answer would result in a permission denied message, not access to the object.

    Ross Hamilton

    DBA

    I think the assumption is that the developers are using the same login as Jon. Since Jon created the stored procedure, he knows that he has to prefix the user account to access it.

    If that's not the case, then you're right. Access Denied error.

  • October 22, 2003 at 8:39 am

    #479118

    If i want to return all the records affected in the same procedure.. how it would be changed?

    Thanks,

    Ramesh.

  • October 23, 2003 at 1:26 am

    #479222

    quote:

    Yeh pat yourself on the back, sycophants united. No one likes a smart a$$

    Besides, the higher your pedestal the further you fall.

    Cheap shot !! Old Guy. I am here just to learn few things from sa like you.

  • October 23, 2003 at 2:06 am

    #479229

    half the posts we were talking about have now been deleted, so confused .

    edwin_fredrick: generally when I'm saying something I mean as a joke or not to be taken seriously I stick a smiley at the end, I guess stuff you can say comes out different in plain text, I apologise for any offence caused

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

  • October 23, 2003 at 2:53 am

    #479235

    quote:

    edwin_fredrick: generally when I'm saying something I mean as a joke or not to be taken seriously I stick a smiley at the end, I guess stuff you can say comes out different in plain text, I apologise for any offence caused

    Same goes here. It may seem cheap but was meant as a joke (hence the clown). I would never use a forum to intentionally denigrate anyone.

    quote:

    half the posts we were talking about have now been deleted, so confused

    This may have added to the percieved cheapness.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 23, 2003 at 2:56 am

    #479236

    Sorry, I deleted my response, because I saw edwin_fredrick did the same.

    So I thought no further need.

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply