Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jason Shadonix Stored Procedure Execution RE: Stored Procedure Execution

  • June 9, 2010 at 8:27 am

    #1177989

    prashant.bhatt (6/9/2010)

    Very Nice question

    I am not sure but the query is returning me 5....

    I dont have the AdventureWorks db on the server...

    Tried using the test database with dbo schema.... may be this is why the results are different for me

    Yes, if DBO is your default schema and you create the stored procedure in the DBO schema that returns 5, then that is the version of the stored procedure that will execute.