Edit Server Registration Properties

Question

Post reply

Edit Server Registration Properties

David-155102

SSCarpal Tunnel

Points: 4361
More actions
August 9, 2005 at 5:09 am

#90574

Is it possible to change the registration properties using TSQL? I want to change the User and Password settings.

Thanks

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Roy Rogers SSCertifiable Points: 7712 More actions · Answer 1

You can check & change logon and user properties using system stored procedures like

sp_addlogin

sp_adduser

sp_helplogins

sp_change_users_login

sp_dropuser

sp_helpuser

Regards,
gova

David-155102 SSCarpal Tunnel Points: 4361 More actions · Answer 2

Hi Govinn,

Will any of these sps allow me to edit SQL Server registration properties (right click on database in EM)

Thanks

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

No, that is a client configuration. It is not stored in the server you connect to so you can't access it by T-SQL.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Roy Rogers SSCertifiable Points: 7712 More actions · Answer 4

Most of the functions in EM are done by some sytem stored procedures. Run SQL - Trace. Do your modifications in EM. You will find the command in the trace.

If you are looking for a specific function many people in this forum will able to give an answer.

As Chris pointed - Server registration cannot be done with TSQL. If so it would be easy to register multiple servers like cake.

Regards,
gova

David-155102 SSCarpal Tunnel Points: 4361 More actions · Answer 5

Ok, thank you both for your help anyway.

Regards

David