stored procedure Matrix

Discussion in 'WebMatrix' started by bosstep, Apr 7, 2003.

  1. Hi:

    as it turns out, just the name of the stored procedure works.

    so, no need for ???????.TESTproc, just TESTproc

    bosstep
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    Yes. Unless your login is associated with multiple database, the system should automatically find the right database.

    FYI, the correct notation is

    database_name.dbo.object_name (where object_name is SP, table, views, etc)




    quote:Originally posted by bosstep

    Hi:

    as it turns out, just the name of the stored procedure works.

    so, no need for ???????.TESTproc, just TESTproc

    bosstep
    </blockquote id="quote"></font id="quote">
     
  3. Hi:

    I trying to use Stored Procedure with Matrix. I've been able to get this to work locally. Having a bit of a problem on remote site. What is the "owner" reference refer to on discount asp.net (??????? below)?

    THanks.

    bosstep

    // TODO: Updatd the name of the Stored Procedure for your application
    string CommandText = "???????.TESTproc";
     

Share This Page