ALTER CREDENTIAL SYNTAX – SQL SERVER

Posted on : 05-07-2011 | By : Devi Prasad | In : Credentials

0



ALTER CREDENTIAL SYNTAX

SYNTAX:

ALTER CREDENTIAL credentialname WITH IDENTITY = 'identityname'
    , SECRET = 'secret' 

The IDENTITY and SECRET for a credential can be changed using ALTER CREDENTIAL.

Example of Alter Credential:

USE [master]
GO
ALTER CREDENTIAL [credential1] WITH IDENTITY = N'username1', SECRET = N'password1'
GO

USING SQL SERVER MANAGEMENT STUDIO (SSMS) TO ALTER CREDENTIAL:

  • Open SSMS and connect to the server in object explorer.
  • Expand server and Security
  • In Security Expand
    Alter Credential

    Double Click on the credential name

  • DoubleClick on the Credential name
  • Credential properties dailog will pop up

    Credential Properties

    Credential Properties

  • Now change the credential properties such as IDENTITY, Password and click on Ok



Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here


Tags: , , ,