Below is the sql query I'm using to check the locks as a scheduled job to run every 5 minutes.. But I would need to create a new seperate output...

Thanks Lowell. I've asked the application team to provide the code.. I have been told this particular SQL is executed in a loop but would be interesting to look in...

Thanks Lowell. I've asked the application team to provide the code.. I have been told this particular SQL is executed in a loop but would be interesting to look in...

Thanks a lot Lowell. CTE works perfect. This sql is run within a loop in a program and it is causing performance issue.. I have created a topic(Remote Query to...

Hi Sean,

THanks so much for your quick response... I really appreciate it. I tried a few different variations with your example, I think I'm pretty close but not yet...

Thanks Sean. I used try-catch as below, it gives the detailed error message... we would need just the procedure to return 'failure' when the procedure fails...

CREATE procedure temp

as

BEGIN

...

Thanks for your replies.. we need to migrate 3-4 tables in Oracle to MSSQL and refresh the data on an ongoing basis.

There are about 50000 records in each table...

Thanks a ton. It works

Anyone please?

I get this error when I query

select * from LINK..ORACLEUSER2.TABLE2;

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "ORAOLEDB.ORACLE" for linked server "LINK" does not contain the table...

Hi friends,

We have created LInked server to oracle database and have synonyms created for few Oracle tables(example - tablename@link) in the SQL database to access from the application. For example,

table1...

Thanks everyone. It was scheduled job..

That helps. Thanks a lot Lowell!!

Thanks a lot.

Another question, when the users run a select on the Oracle table via linked server from SQL db, will there a lock created in the sql database?...

Thank you everyone. I was able to get only the character fields in LOwer case with the below SQL

SELECT

'EXEC sp_rename ''' + TABLE_SCHEMA + '.' + TABLE_NAME + '.' +...