Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Create the link to server "uranium"
- EXEC master.dbo.sp_addlinkedserver
- @server = N'uranium',
- @srvproduct=N'',
- @provider=N'SQLNCLI'
- --Add the catch-all login with SQL Server authentication
- EXEC master.dbo.sp_addlinkedsrvlogin
- @rmtsrvname=N'uranium',
- @useself=N'False',
- @locallogin=NULL,
- @rmtuser=N'BatteryStaple',
- @rmtpassword='Horsecorrect'
- SELECT * FROM uranium.Periodic.dbo.Users
- Msg 18456, Level 14, State 1, Line 1
- Login failed for user 'BatteryStaple'.
- --Create the link to server "uranium"
- EXEC master.dbo.sp_addlinkedserver
- @server = N'uranium',
- @srvproduct=N'', @provider=N'SQLNCLI'
- --Create the link to SQL Server "uranium"
- EXEC master.dbo.sp_addlinkedserver
- @server = N'uranium',
- @srvproduct=N'SQL Server'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement