Annotations for "CREATE CREDENTIAL (Transact-SQL)" topic.Fri, 09 Dec 2016 16:32:07 Zhttp://technet.microsoft.com/en-us/library/ms189522(v=sql.100).aspx#CommunityContent
Chris HowarthError in DocumentationThe documentation appears to be incorrect:
“A SQL Server login can be mapped to only one credential, but a single credential can be mapped to multiple SQL Server logins. For more information, see Credentials (Database Engine).”
This appears not to be the case for EKM-based credentials, see the repro script below:
USE [master]GOCREATE CREDENTIAL [TestCredential1]WITH IDENTITY = N'TestCredential1',SECRET = N'TestCredential1'GOCREATE LOGIN [TestLogin1]WITH PASSWORD = N'!"£$%^',DEFFri, 04 Sep 2009 09:19:55 -0700