Can I disable log for a table?

Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
MaxNo. You can change the recovery model but only at the database level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
Max|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> No. You can change the recovery model but only at the database level.
True, but to be complete, you can change it to a simple recovery model but
some logging still occurs.
So you can't elimiante it cmopletely.

> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>|||"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>
You could put the table in its own database and use the Simple Recovery
model in that database. You can then create the reference to that table as a
view or synonym in another database.
Think about the consequences for your data integrity if you ever have to
restore the transaction log.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||You can eliminate logging completely, but you have to place the database in
a read only state to do so.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> True, but to be complete, you can change it to a simple recovery model but
> some logging still occurs.
> So you can't elimiante it cmopletely.
>
>|||"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u5zmgmcYGHA.4796@.TK2MSFTNGP04.phx.gbl...
> You can eliminate logging completely, but you have to place the database
in
> a read only state to do so.
Details, details. ;-)
But I have to admit that's true.

> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
but[vbcol=seagreen]
server?[vbcol=seagreen]
>