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.
| Author |
Topic |
|
marty1976
Starting Member
22 Posts |
 Posted - 2011-07-28 : 11:51:01
|
| Hi,sys.linked_logins has a column "uses_self_credential". I'l like to change one the values using SQL, but as this is a system table I can't just UPDATE it.Is there any way to get this done with t-sql? |
|
|
marty1976
Starting Member
22 Posts |
Posted - 2011-08-04 : 11:13:20
|
| Just in case someone else needs this:EXEC sp_addlinkedsrvlogin @rmtsrvname = 'EXCEL_TEST' ,@useself = FALSE ,@locallogin = 'something' ,@rmtuser = NULL ,@rmtpassword = NULL This only works when both rmtuser and rmtpasswort are NULL |
 |
|
|
|
|
|
Set security of linked server