SHARE
TWEET

Untitled

a guest Jun 17th, 2019 101 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --Create the link to server "uranium"
  2. EXEC master.dbo.sp_addlinkedserver
  3.       @server = N'uranium',
  4.       @srvproduct=N'',
  5.       @provider=N'SQLNCLI'
  6.  
  7. --Add the catch-all login with SQL Server authentication
  8. EXEC master.dbo.sp_addlinkedsrvlogin
  9.       @rmtsrvname=N'uranium',
  10.       @useself=N'False',
  11.       @locallogin=NULL,
  12.       @rmtuser=N'BatteryStaple',
  13.       @rmtpassword='Horsecorrect'
  14.      
  15. SELECT * FROM uranium.Periodic.dbo.Users
  16.      
  17. Msg 18456, Level 14, State 1, Line 1
  18. Login failed for user 'BatteryStaple'.
  19.      
  20. --Create the link to server "uranium"
  21. EXEC master.dbo.sp_addlinkedserver
  22.       @server = N'uranium',
  23.       @srvproduct=N'', @provider=N'SQLNCLI'
  24.      
  25. --Create the link to SQL Server "uranium"
  26. EXEC master.dbo.sp_addlinkedserver
  27.       @server = N'uranium',
  28.       @srvproduct=N'SQL Server'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top