CHANGE OF USER NAME - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

CHANGE OF USER NAME

Author

Topic

siva.meti
Starting Member

32 Posts

Posted - 2007-09-24 : 12:33:33

Hi Friends,

I want to change my USER NAME of the USER.

CHANGE THE OWNER SHIP Of the user 'shiv' - 'kumar'

what is command of that one OR GUI how can i change plz explain me

Meti BEST OF THE BEST

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-24 : 13:26:55

http://msdn2.microsoft.com/en-us/library/ms176060.aspx

Future guru in the making.

siva.meti
Starting Member

32 Posts

Posted - 2007-09-24 : 20:23:18

Hi can u any body plz explain me

How can i change server1.dbo.table1.alterprocedure

I want to change dbo name how can i change plz help

it is queryanalylizer how ?
Enterprise manager how ? pLZ EXPLAINE ME
THX

Meti BEST OF THE BEST

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-24 : 20:24:43

sp_changeobjectowner

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources