default isolation level

Hi all,
the default isolation level in sql 2k is read committed..
say incase i am connecting to the DB through a jdbc driver and the
application has a default isolation level of repeatable read...
when a transaction is opened from the application end...wat would be the
isolation level...
ll the db override or the application takes up priority..
any help on the context is appreciated..
thnks
anu
Application should override the default level.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Anuradha" <Anuradha@.discussions.microsoft.com> wrote in message
news:C46A6429-6D51-40BF-A4EE-9584224F3625@.microsoft.com...
> Hi all,
> the default isolation level in sql 2k is read committed..
> say incase i am connecting to the DB through a jdbc driver and the
> application has a default isolation level of repeatable read...
> when a transaction is opened from the application end...wat would be the
> isolation level...
> ll the db override or the application takes up priority..
> any help on the context is appreciated..
> thnks
> anu

default isolation level

Hi all,
the default isolation level in sql 2k is read committed..
say incase i am connecting to the DB through a jdbc driver and the
application has a default isolation level of repeatable read...
when a transaction is opened from the application end...wat would be the
isolation level...
ll the db override or the application takes up priority..
any help on the context is appreciated..
thnks
anuApplication should override the default level.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Anuradha" <Anuradha@.discussions.microsoft.com> wrote in message
news:C46A6429-6D51-40BF-A4EE-9584224F3625@.microsoft.com...
> Hi all,
> the default isolation level in sql 2k is read committed..
> say incase i am connecting to the DB through a jdbc driver and the
> application has a default isolation level of repeatable read...
> when a transaction is opened from the application end...wat would be the
> isolation level...
> ll the db override or the application takes up priority..
> any help on the context is appreciated..
> thnks
> anu

Default base

Hi,

On first sqlserver install, what's the default base to test connect
with JDBC please ?
Is it "system" base with sa/master password ?

Thanks,

--
Jean-Luc M."Jean-Luc M." <alphomega@.free.fr> wrote in message
news:mn.5bb97d537c60e520.28556@.free.fr...
> Hi,
> On first sqlserver install, what's the default base to test connect with
> JDBC please ?
> Is it "system" base with sa/master password ?
> Thanks,
> --
> Jean-Luc M.

By default, you are 'in' the master database when you connect to MSSQL. If
you have just installed MSSQL, then you can either connect with the sa
account if you chose mixed mode authentication, or a Windows user in the
local administrators group is you chose Windows-only authentication. But I
guess if you're using JDBC, then you'll probably need to use the sa account.

Simon|||>
> By default, you are 'in' the master database when you connect to MSSQL. If
> you have just installed MSSQL, then you can either connect with the sa
> account if you chose mixed mode authentication, or a Windows user in the
> local administrators group is you chose Windows-only authentication. But I
> guess if you're using JDBC, then you'll probably need to use the sa account.

Thanks a lot !

--
Jean-Luc M.