Thank you both.

Thanks Mark. We are proposing to use OLE DB provider for Oracle as well on ORacle 10g. So would be a similar setup..

Can you please tell me what the location...

Thanks Mark. That was clear enough. Hope I got that right.. the windows authentication will be the set up with the ODBC connection to the Oracle server and the linked...

Please help me , anyone?

Just trying to get more information on this.. If there could be any possible security issues, as far as the setup is concerned I...

Thanks so much Lowell. You sure made it clear. I greatly appreciate it.

I need more help from you experts.. I'm following this doc to find out about how to...

Thank you so much Lowell.

Is linked server, the only option to access Oracle database from SQL server stored Procedure? Is linked server, basically like a database object like...

So, there is no lock in the SQL server?

Can you please tell me how can I find the locked table in the database? I tried sp_lock but it...

Thanks a million

Thanks I got that working.

But I've another problem. I have a column a with datatype varchar(19). If I insert a string with 15 characters it should automatically insert spaces...

Thanks, the INIT worked.

Thanks for the replies. The database sizes varies from 1GB to 50GB..

I'll include INIT and schedule the backups tonight.

Thanks again

Hi Roy,

I removed Noinit from the command for last night backups, I still see the big size backups this morning.

Any other suggestions?

Thanks alot

I've the same issue still going on.. At this stage, we just want to provide our clients with what they will need to do when the master key gets corrupted.....

Thank you

Thanks for all your valuable replies. I appreciate it. I'll change the backup timing tonight and see if it is any better.