How to run
the tables & Store procedure from one database to another database using
SQL Server
For
Execution the Table
EXEC sys.sp_dropserver @server
= 'VCNSQL90.sample.com', @droplogins = 'droplogins';
EXEC master.dbo.sp_addlinkedserver @server = N'VCNSQL90.webhost4life.com',
@srvproduct=N'VCNSQL90.
sample.com', @provider=N'SQLNCLI', @datasrc=N'VCNSQL90. sample.com'
/* For security
reasons the linked server remote logins password is changed with ######## */
EXEC...