Re: sqltransaction

so if you use simple stored procedure, everything is ok? so the code in your
stored procedure may be doing something with the master id.. it is just a
guess.. try to catch the call to mastersp in profiler and execute it in
query analyzer. modify stored procedure to display everything that interests
you.
on the other hand sp vs views. as Chad said in other thread, there are
situations when view is more convenient to use. In my recent project i have
5 views to retrieve some data, but usually I use stored procedures.

Peter


.

Relevant Pages

  • Re: UPDATE problems with Parameters
    ... the parameters defined in your stored procedure. ... Peter ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Stored procedure, which table is used ?
    ... I believe that you can mark a stored procedure as a "proper" system stored ... > A stored procedure in the master database. ... > run in the Query analyser under local database. ... > use LocalDatabase ...
    (microsoft.public.sqlserver.server)
  • Re: osql
    ... State 62, Server NXP353467\ORDERS, Line 4 ... Could not find stored procedure 'sp_add_jobstep'. ... >For the backup error, you can't do a log backup if a ... >> USE master ...
    (microsoft.public.sqlserver.tools)
  • Stored procedure, which table is used ?
    ... >run in the Query analyser under local database. ... probably be run in Master even if called from a user db. ... >A stored procedure in the master database. ... >select 'LocalDatabase' as OKKI INTO DEMOTABLE ...
    (microsoft.public.sqlserver.server)
  • SA connection problems.
    ... but can anyone tell me how to get the stored procedure ... I have checked in the MASTER DB and the ... >IS missing. ...
    (microsoft.public.sqlserver.security)