change table name

What is the syntax for changing a table name? Can not find it in my
reference books.
Thanks
Laura KNever mind. By brain is turned off. I did a search. Found it.
Laura K
"Laura K" <klkazanAT@.ATcharter.net> wrote in message
news:uqrkEU$WFHA.3464@.TK2MSFTNGP10.phx.gbl...
> What is the syntax for changing a table name? Can not find it in my
> reference books.
> Thanks
> Laura K
>|||Hi !
Try This
use northwind
EXEC sp_rename 'customers', 'custs'
select * from custs--for cross checking
Regards
Swati Zingade
*** Sent via Developersdex http://www.examnotes.net ***

Change Password After 1st Login

I've tried Books Online, MSDN online and google but cannot get the answer.
Can I get ann SQL account configured such that the user will have to change
the next time they login.
Apologies if this is a simple flag somewhere but I can assure you I have
tried to find the answer.
Any help welcome.
MPMForgot to mention SQL 2000 + SP3a
"MANCPOLYMAN" wrote:
> I've tried Books Online, MSDN online and google but cannot get the answer.
> Can I get ann SQL account configured such that the user will have to change
> the next time they login.
> Apologies if this is a simple flag somewhere but I can assure you I have
> tried to find the answer.
> Any help welcome.
> MPM|||You can't do this in SQL2000. You will be able to do this in SQL2005 using
the MUST_CHANGE option for CREATE/ALTER LOGIN.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:86EFDFC9-3AAE-4397-8722-671962F54AB1@.microsoft.com...
> Forgot to mention SQL 2000 + SP3a
> "MANCPOLYMAN" wrote:
>> I've tried Books Online, MSDN online and google but cannot get the
>> answer.
>> Can I get ann SQL account configured such that the user will have to
>> change
>> the next time they login.
>> Apologies if this is a simple flag somewhere but I can assure you I have
>> tried to find the answer.
>> Any help welcome.
>> MPM