Tag Info

New answers tagged

0

I found the solution that I wanted: -- how to disable a linked server --check the existent linked servers SELECT * FROM SYS.SERVERS WHERE NAME = 'SWLON1' -- Disable data access EXEC sp_serveroption @server = 'SWLON1' ,@optname = 'data access' ,@optvalue = 'FALSE' -- ABOUT procedure sp_serveroption ...


3

As I understand it, this is because the SID's of the logins don't match between our two environments. You understand correctly! How could I make it so that the SID's of the sql server logins on our staging environment are the same as on our production environment going forward? My thought is to use CREATE LOGIN WITH SID ='SID value from PRD' ...


1

I had thought you would be able to use policy based management but couldn't find a way to get the PasswordLastSetTime property. It didn't exist in the Login facet. However what you an do is run the following query to get the PasswordLastSetTime for all SQL Logins on the instance, then use a tool such as Idera's Multi Query or a CMS (Central Management ...



Top 50 recent answers are included