priki
Član broj: 24732 Poruke: 700 212.103.132.*
ICQ: 174153511
|
jesam aktivirao sam upravo i isto se desava, ne znam vise gde da gledam,
DTC su aktivirani na svim mašinama
na mreži je domen, ali nema nikakvih posebnih permission-a
svi portovi unutar mreže su otvoreni
šta pokušavam, pa ako se na jednoj mašini u nekoj tabeli unese slog
da isti taj slog ode i na drugi server u identičnu bazu i tabelu
(collation je isti i na bazi i na tabeli)
jedino, jel moze biti problem ako mi je taj server virtual masina a
racunari su fizicki pristuni
evo i skripte
hvala
Srdjan
****************************************************
use master
go
IF EXISTS(SELECT * FROM master.dbo.sysservers WHERE srvname ='MIRAN')
EXEC sp_dropserver 'MIRAN','droplogins'
exec sp_addlinkedserver @server = N'MIRAN',
@srvproduct = N'',
@provider = N'SQLOLEDB',
@catalog = N'proba_linked'
go
exec sp_addlinkedsrvlogin 'MIRAN','false', 'sa', 'sa', 'passwdw'
go
exec sp_serveroption N'MIRAN', N'rpc', N'true'
go
exec sp_serveroption N'MIRAN', N'rpc out', N'true'
go
use proba_linked
go
set ansi_nulls off
GO
set ansi_warnings off
go
if exists(select * from sysobjects WHERE name='test' and type='U ')
drop table test
GO
create table test (
sifra int NOT NULL PRIMARY KEY,
naziv nvarchar(50))
go
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TEST_INSERT' AND type = 'TR')
drop trigger TEST_INSERT
GO
SET XACT_ABORT ON
go
SET IMPLICIT_TRANSACTIONS OFF
go
SET REMOTE_PROC_TRANSACTIONS OFF
go
SET ANSI_NULLS ON
go
SET ANSI_WARNINGS ON
go
CREATE TRIGGER [TEST_INSERT] ON [dbo].[test]
FOR INSERT
AS
SET XACT_ABORT ON
BEGIN DISTRIBUTED TRAN pepe
INSERT INTO OPENQUERY(MIRAN, 'select sifra, naziv from proba_linked.dbo.test where 1=0')
SELECT sifra, naziv
FROM inserted
COMMIT TRAN pepe
SET implicit_transactions on
SET REMOTE_PROC_TRANSACTIONS ON
GO
INSERT INTO TEST(sifra,naziv)
values(1,'prvi unos')
GO
|