Re: Autocommit and stored proc

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 14:53:54 -0600

As stated read committed, and no, it is the same everywhere. I am pretty
sure that it can be overridden by your connection settings, but if it is
unstated elsewhere, read committed. 

-- 
----------------------------------------------------------------------------
-----------
Louis Davidson (drsql@hotmail.com)
Compass Technology Management
Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are
interested in consulting services.  All other replies will be ignored :)
"mannie" <anonymous@discussions.microsoft.com> wrote in message
news:B330BA00-57C4-4C56-BA94-8602B20D0627@microsoft.com...
> How can I tell what default transaction mode sql 2000 is in?
> Does it differ if you use stored proc or inline sql?

Relevant Pages

  • RE: Please help: steps to go from SQL Express and SQL 2005 Production
    ... Here is a little background and also how to modify the connection settings: ... the MDF files are not attached to the SQL database. ... My SQL Host ISP only has one database and I want to consolidate all the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Limit data to users own
    ... However for my account it's returning dbo. ... I checked my connection settings and they are using SSPI. ... I ran it in QUery Analyzer and it also returned dbo. ... >> Windows Authentication on the site and for SQL Authentication. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Duplicate logon to Access and SQL Server
    ... if you are using linked tables or pass-through queries - then all connection settings in connection strings ... I've set up all user accounts (the server use SQL ... to logon only to Access, but others are requested to logon both to Access and ...
    (microsoft.public.access.modulesdaovba)
  • Re: MS SQL to MS Access ASP problem
    ... Please forgive me for posting OT msg here but I need to get this ... > ASP program to work with ms access instead of ms SQL... ... In theory, just the connection settings. ...
    (comp.lang.php)
  • Re: Cannot access stored procedures
    ... We have users that connect to the SQL database ... >were running SQL 7. ... >connection settings, but when they click on one of the buttons for the ...
    (microsoft.public.access.adp.sqlserver)