- nothing changed it the subscriber, it's only online to test the connections

- no triggers

But it's possible the last reason, gonna check the update queries... thx

Colleen M. Morrow (6/28/2011)

---

From BOL:

Data...

There was 1 table missing 1 row.. 🙁

Thanks for the help...

I didn't found 'SqlPubWiz.exe', so I've done it with the Generate script... 🙂

No one knows what could be wrong?

You can save this query and run the Database Engine Tuning Advisor against it...

This will create scripts to make your indexes

Thanks for the info.

I will ask the application owner to check this problem... hope they can change there working principle.

OPENQUERY worked without any problem.

Not tried... I will do

But I cann't change the query itself, because it's programmed already in the application 🙁

More info (in meanwhile I'm still googling around):

- All tables in the view have PK

- No triggers in the remote db

More info:

SELECT u.NAME FROM [SQLVACRE052-053].Interactive.vac.RegisteredUser u WHERE u.ID=1117698

SELECT NAME FROM dbo.Regusers_VACREF WHERE ID=1117698

Both query's are ok, no problems here (with a select), only with the update...

Isn't it possible with the registered servers window?

- Create group and place all connections (per instances) in it

- Right click on the group and select 'New query'

- Execute your query...

Ok, we will test it with the application..

Many thanks for your knowledge 🙂

crazy4sql (6/9/2011)

---

yes, create same login and pwd in both server and give required permission.

You will be able to connect the database.

Its like you can have same name and password for...

Hello crazy4sql,

Yes both servers can ping each other and both can be ping'd by the application server.

For the SQL login:

I need to create 1 login on both servers (same name...

It's not possible to restore the restoring db as a copy, so the actual restoring db keeps available for log shipping?