i've done below.....

CREATE TRIGGER TRG_TMP

AFTER INSERT OR UPDATE OR DELETE

OF ID or Stud_Name

ON

STUD

BEGIN

--

here i need oracle query to compare the ID, stud_name in two tables,

and i...

Thanks Thanks ......................... Ton of Thanks.

Success,

thank u team, i've started the distributed query without basic knowledge, i tried a lot,

but ur help make me understand that exactly what it...

If i use like "SHH004V\SVR5"

getting below error.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '\'.

getting below error

Could not find server 'SHH004V' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

Can u please provide the query plz,

Hello Sir,

finally i've configured Linked Server.

but am unable to execute the query.

using below syntax:

SELECT * FROM serverA.database.owner.TableName

Union

SELECT * FROM serverB.database.owner.Tablename

Server name am gettting from "SELECT @@SERVERNAME" is it OK.

select * from Stud_Info

left inner join SVSINST\SR2002.students.stud_Info

Query Looks great,

But i want to retrieve unmatched records from two seperate instances.

Instance : A

Database : Students

Table : Stud_Info

Instance : B

Database : Stud

Table : Stud_Info.

output should be displayed from stud_info...

Am using below query, but not executing,

select * from Stud_Info

left inner join SVSINST\SR2002.students.stud_Info

Please help me in query building....

Hi Team,

Sample query Please........

There are no triggers on particular table.

am inserting manually, i.e

insert into table_name values (.....)

Thnak u,

Really Helpful.

Thanks a LOT:-)

Thank U Abu.

Hi Thank u for your reply,

but the query is not feching all the definitions which are having cursors, only few definication is getting.

how to get all objects / definition.

Hi Team,

Please suggest the best join to get the records(avioiding duplicates)

am having 20 joins.

if particular record is not there in that table, then it should not join that table,

like...