Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM sys.servers AS s
- EXEC sp_DROPSERVER 'USERNAME\MSSQLSERVER2012'
- EXEC sp_ADDSERVER 'USERNAME', 'local'
- EXEC sp_serveroption 'USERNAME', 'DATA ACCESS', TRUE
- SELECT * FROM sys.servers AS s
Add Comment
Please, Sign In to add comment