Category: SQL-Linked Server

SQL Server – Linked Server – Mapped all users with one statement

SQL, SQL-General, SQL-Linked Server, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Hello Friends, I have setup the Linked server with the help of script here. My one of colleague helps me to write the script with we can map all user with one statement. This script will map all local SQL server users with remote user that you provide in the

» Read more
, ,

SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY not working with Linked Server or Remote server ???

SQL, SQL-Linked Server, Varinder Sandhu

Hello Friends, I have faced a problem using SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY with Linked server Let me explain with example as below Question: We have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set of applications to SQL 2008. Now

» Read more
, , , ,

Linked Server

SQL, SQL-General, SQL-Linked Server, SQL-Query, SQL-Scripts, Varinder Sandhu

——————————————————— Create  Linked Server through Scripts ——————————————————— USE [master] GO EXEC sp_addlinkedserver @server=’dsql2k’, @srvproduct=”, @provider=’SQLNCLI’, @datasrc=’source_name’ GO USE [master] GO EXEC master.dbo.sp_serveroption @server=N’dsql2k’, @optname=N’rpc’, @optvalue=N’true’ GO EXEC master.dbo.sp_serveroption @server=N’dsql2k’, @optname=N’rpc out’, @optvalue=N’true’ GO select * from master.dbo.sysservers ————————————————————————— Alternative Script to Create Linked Server and Mapping of Users ————————————————————————— Use

» Read more
, , ,