How do i disable Windows Authentication mode to log into the DB?

How do i disable Windows Authentication mode and just have SQL Server Authentication mode?

is it even possible?

Yes possible. Right click on the Server -> Properties -> Security.|||

theres only two choices:

Windows Authentication mode OR BOTH Windows and SQL Authentication.

I just want SQL Authentication.

|||You cannot disable windows authentication entirely. Also, enabling windows authentication does not mean every windows user can login. The windows login should be added to the logins module to access the db.

How do I disable transaction logging in a stored procedure?

Greetings,

I would like to turn off transaction logging for a long-running stored procedure. It is doing some one-shot utility work in a temporary table. If the stored procedure fails then I'll delete all the rows in the table.

Is is possible to turn off (or at least minimize) the logging for a single stored procedure? I'm looking at this from a performance perspective, thinking that doing no logging will speed things up a bit. The stored procedure will potentially update hundreds of thousands rows.

Am I on the right track or barking up the wrong tree?

Thanks,

BCB

hello,

everything that happens in the database are entered into the transaction log

when you are in the full recovery.

you may only choose any of the three recovery model to handle the log size

1. simple

2. bulk logged

3. fully logged

you can deal with the logs only as a part of your db maintenance procedure.

thanks,

joey

How do I disable the help (?) link?

I'm using RS 2000 SP2 and have implemented a custom security extension.
The reports are embedded in our web application. Everything works
great except for the help link, which when clicked, launches an IE
window that displays the login page. Is there any way to disable,
hide, or change the href for this link?
TimCan someone please just tell me it's not possible so that I can stop
asking?

How do I disable Named Pipes in SQL 7?

Hi All
I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
Named Pipes is ticked, but greyed out in the server
network utility. I only want to use TCP/IP. Does SQL 7
require Named Pipes? Can you not remove it?
Thanks
HH wrote:
> Hi All
> I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
> Named Pipes is ticked, but greyed out in the server
> network utility. I only want to use TCP/IP. Does SQL 7
> require Named Pipes? Can you not remove it?
> Thanks
> H
I believe SQL 7 uses Named Pipes connections for some internal
processing or possibly with tools on the server like SQL EM. You can
remove the protocol from clients. You might be able to change the
default pipe name on the server so clients have a harder time
accidentally connecting using named pipes.
--
David Gugick
Imceda Software
www.imceda.com

How do I disable Named Pipes in SQL 7?

Hi All
I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
Named Pipes is ticked, but greyed out in the server
network utility. I only want to use TCP/IP. Does SQL 7
require Named Pipes? Can you not remove it?
Thanks
H
H wrote:
> Hi All
> I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
> Named Pipes is ticked, but greyed out in the server
> network utility. I only want to use TCP/IP. Does SQL 7
> require Named Pipes? Can you not remove it?
> Thanks
> H
I believe SQL 7 uses Named Pipes connections for some internal
processing or possibly with tools on the server like SQL EM. You can
remove the protocol from clients. You might be able to change the
default pipe name on the server so clients have a harder time
accidentally connecting using named pipes.
David Gugick
Imceda Software
www.imceda.com

How do i disable access to Enterprise Mananger for a sql2000 serve

i need to prevent developers accidently starting a passive sql2000 server
when they see it down in EM (right click-start). Is there a way i can do
this, but still allow the developers to work with the dbs?
thankssimon
As far as I know you cannot
"simon.yeats" <simonyeats@.hotmaildotcom(donotspam)> wrote in message
news:5481A9A0-D3F5-457A-B127-383ED74A7BF9@.microsoft.com...
>i need to prevent developers accidently starting a passive sql2000 server
> when they see it down in EM (right click-start). Is there a way i can do
> this, but still allow the developers to work with the dbs?
> thanks

how do I disable "strong password required"?..

how do I disable "strong password required"? because I want to allow to add a user with the config-tool with no strong passwordWhen you create a user in the management studio there is an option to disable the password policy. As for using the config tool I could not see where you where creating logins...

How do I determine if SQL Sever Login is disabled using T-Sql?

How do I determine if SQL Sever Login is disabled using T-Sql?
I can disable it and enabled it using the following T-Sql function:
ALTER LOGIN login [ENABLE | DISABLE]
I just want to know if it is enable or disabled?It's stored in the system table sys.server_principals, in the column called
is_disabled
However, in SQL Server 2005 system tables are not visible by default; you
must use the Dedicated Administrator Connection (DAC) which you can read
about in the Books Online.
--
HTH
Kalen Delaney, SQL Server MVP
<rodrigo.gloria@.gmail.com> wrote in message
news:1156370327.654473.140550@.p79g2000cwp.googlegroups.com...
> How do I determine if SQL Sever Login is disabled using T-Sql?
> I can disable it and enabled it using the following T-Sql function:
> ALTER LOGIN login [ENABLE | DISABLE]
> I just want to know if it is enable or disabled?
>|||Hi,
You can also query the system view and look into column is_disabled.1
denotes the login is disabled
select * from sys.sql_logins
Tahnks
Hari
SQL Server MVP
<rodrigo.gloria@.gmail.com> wrote in message
news:1156370327.654473.140550@.p79g2000cwp.googlegroups.com...
> How do I determine if SQL Sever Login is disabled using T-Sql?
> I can disable it and enabled it using the following T-Sql function:
> ALTER LOGIN login [ENABLE | DISABLE]
> I just want to know if it is enable or disabled?
>|||Thanks Hari. I totally blew that answer. I was doing some testing, and was
in a connection that was not a sysadmin, just a regular user. So when I
couldn't see server_principals, I assumed it was because it was a system
table.
Then of course logging in using the DAC, I was sysadmin, so I could see that
view.
So sys.server_principals is the answer.
If you check the BOL for sys.sql_logins, you'll see that it is a view based
on sys.server_principals, containing all the columns from that view, plus a
view others.
--
HTH
Kalen Delaney, SQL Server MVP
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OLo8wkxxGHA.2168@.TK2MSFTNGP06.phx.gbl...
> Hi,
> You can also query the system view and look into column is_disabled.1
> denotes the login is disabled
> select * from sys.sql_logins
>
> Tahnks
> Hari
> SQL Server MVP
> <rodrigo.gloria@.gmail.com> wrote in message
> news:1156370327.654473.140550@.p79g2000cwp.googlegroups.com...
>> How do I determine if SQL Sever Login is disabled using T-Sql?
>> I can disable it and enabled it using the following T-Sql function:
>> ALTER LOGIN login [ENABLE | DISABLE]
>> I just want to know if it is enable or disabled?
>|||Kalen Delaney wrote:
> Thanks Hari. I totally blew that answer. I was doing some testing, and was
> in a connection that was not a sysadmin, just a regular user. So when I
> couldn't see server_principals, I assumed it was because it was a system
> table.
> Then of course logging in using the DAC, I was sysadmin, so I could see that
> view.
> So sys.server_principals is the answer.
> If you check the BOL for sys.sql_logins, you'll see that it is a view based
> on sys.server_principals, containing all the columns from that view, plus a
> view others.
> --
> HTH
> Kalen Delaney, SQL Server MVP
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OLo8wkxxGHA.2168@.TK2MSFTNGP06.phx.gbl...
> > Hi,
> >
> > You can also query the system view and look into column is_disabled.1
> > denotes the login is disabled
> >
> > select * from sys.sql_logins
> >
> >
> >
> > Tahnks
> > Hari
> > SQL Server MVP
> >
> > <rodrigo.gloria@.gmail.com> wrote in message
> > news:1156370327.654473.140550@.p79g2000cwp.googlegroups.com...
> >> How do I determine if SQL Sever Login is disabled using T-Sql?
> >>
> >> I can disable it and enabled it using the following T-Sql function:
> >>
> >> ALTER LOGIN login [ENABLE | DISABLE]
> >>
> >> I just want to know if it is enable or disabled?
> >>
> >
> >
Thank you very much.

How do I determine if SQL Sever Login is disabled using T-Sql?

How do I determine if SQL Sever Login is disabled using T-Sql?
I can disable it and enabled it using the following T-Sql function:
ALTER LOGIN login [ENABLE | DISABLE]
I just want to know if it is enable or disabled?It's stored in the system table sys.server_principals, in the column called
is_disabled
However, in SQL Server 2005 system tables are not visible by default; you
must use the Dedicated Administrator Connection (DAC) which you can read
about in the Books Online.
HTH
Kalen Delaney, SQL Server MVP
<rodrigo.gloria@.gmail.com> wrote in message
news:1156370327.654473.140550@.p79g2000cwp.googlegroups.com...
> How do I determine if SQL Sever Login is disabled using T-Sql?
> I can disable it and enabled it using the following T-Sql function:
> ALTER LOGIN login [ENABLE | DISABLE]
> I just want to know if it is enable or disabled?
>|||Hi,
You can also query the system view and look into column is_disabled.1
denotes the login is disabled
select * from sys.sql_logins
Tahnks
Hari
SQL Server MVP
<rodrigo.gloria@.gmail.com> wrote in message
news:1156370327.654473.140550@.p79g2000cwp.googlegroups.com...
> How do I determine if SQL Sever Login is disabled using T-Sql?
> I can disable it and enabled it using the following T-Sql function:
> ALTER LOGIN login [ENABLE | DISABLE]
> I just want to know if it is enable or disabled?
>|||Thanks Hari. I totally blew that answer. I was doing some testing, and was
in a connection that was not a sysadmin, just a regular user. So when I
couldn't see server_principals, I assumed it was because it was a system
table.
Then of course logging in using the DAC, I was sysadmin, so I could see that
view.
So sys.server_principals is the answer.
If you check the BOL for sys.sql_logins, you'll see that it is a view based
on sys.server_principals, containing all the columns from that view, plus a
view others.
--
HTH
Kalen Delaney, SQL Server MVP
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OLo8wkxxGHA.2168@.TK2MSFTNGP06.phx.gbl...
> Hi,
> You can also query the system view and look into column is_disabled.1
> denotes the login is disabled
> select * from sys.sql_logins
>
> Tahnks
> Hari
> SQL Server MVP
> <rodrigo.gloria@.gmail.com> wrote in message
> news:1156370327.654473.140550@.p79g2000cwp.googlegroups.com...
>