How to set the recovery mode to SIMPLE?

How to set the recovery mode to SIMPLE on the Enterprise
Manager? If not, what is the SQL commend that could set
the Recovery mode to simply and bring it back? Tks!In the Enterprise Manager, you right click on the database, select
properties, then select the options tab, then select sinple in the recover
options drop down list.
To set the database to simple recovery in t-sql, use the alter database
command, eg:
alter database [mydb] set recovery simple
Regards,
Greg Linwood
SQL Server MVP
"KL" <anonymous@.discussions.microsoft.com> wrote in message
news:00c401c3c746$2e42be30$a601280a@.phx.gbl...
> How to set the recovery mode to SIMPLE on the Enterprise
> Manager? If not, what is the SQL commend that could set
> the Recovery mode to simply and bring it back? Tks!

How to set SQL Server only accept SQL Server Authentication mode?

How to set SQL Server only accept SQL Server Authentication mode?
Our company will not use mixed authentication mode, how to switch SQL Server
Authentication?ABC
I don't think you can do that. Either SS2000 and SS2005 accept Windows and
SQL Server and Windows Authentication
However it does not o have onyl SQL Server Authentication.
Why would you want to do that? If you want , you cam build a connection
string to the SQL Server by using SQL Server Authentication by providing a
user and a password but it will be alwasy an another option to connect by
WA.
"ABC" <abc@.abc.com> wrote in message
news:ueCqj69JGHA.916@.TK2MSFTNGP10.phx.gbl...
> How to set SQL Server only accept SQL Server Authentication mode?
> Our company will not use mixed authentication mode, how to switch SQL
> Server Authentication?
>
>
>|||I don't know why.
Our web project is used VS2003 and Crystal Reports for Visual Studio.NET.
There have reports that directly call to sql server's stored procedure. I
also call SetDatabaseLogon method to change user id and password. But I
found the crystal reports use ASPNET account to logon SQL Server, not my
expected user id.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uk5WVE%23JGHA.3896@.TK2MSFTNGP15.phx.gbl...
> ABC
> I don't think you can do that. Either SS2000 and SS2005 accept Windows
> and SQL Server and Windows Authentication
> However it does not o have onyl SQL Server Authentication.
> Why would you want to do that? If you want , you cam build a connection
> string to the SQL Server by using SQL Server Authentication by providing a
> user and a password but it will be alwasy an another option to connect by
> WA.
>
>
> "ABC" <abc@.abc.com> wrote in message
> news:ueCqj69JGHA.916@.TK2MSFTNGP10.phx.gbl...
>|||ABC
Does the server have Mixed Authenitcation or Windows only?
"ABC" <abc@.abc.com> wrote in message
news:%23tATCN%23JGHA.2088@.TK2MSFTNGP11.phx.gbl...
>I don't know why.
> Our web project is used VS2003 and Crystal Reports for Visual Studio.NET.
> There have reports that directly call to sql server's stored procedure. I
> also call SetDatabaseLogon method to change user id and password. But I
> found the crystal reports use ASPNET account to logon SQL Server, not my
> expected user id.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uk5WVE%23JGHA.3896@.TK2MSFTNGP15.phx.gbl...
>|||Mixed mode.
"Uri Dimant" <urid@.iscar.co.il> glsD:%230Zzda%23JGHA.2912@.tk2msftngp13.phx.gbl...[
vbcol=seagreen]
> ABC
> Does the server have Mixed Authenitcation or Windows only?
>
> "ABC" <abc@.abc.com> wrote in message
> news:%23tATCN%23JGHA.2088@.TK2MSFTNGP11.phx.gbl...
>[/vbcol]

how to set a database to readwrite mode

Database was copied to another location in read only mode using enterprise manager. how can you reverse this using query analyzer in the new location?master.dbo.sp_dboption N'<DB Name>', N'read only', N'false'