"I need to run the stored procedure in Sql Server and It's going to be called by Oracle, Oracle has the data."

This sort of information would have been helpful in your original...

Your going down the right track. Instead of using a temp table in tempdb, use a permanent table in your database, or if need be, a seperate staging database. Just truncate...

Are you using an external app (DTS, VB, etc...) which determines if a record exists?

One option is to create a seperate stored procedure for each action. Then create another procedure which...

A good tip for dealing with instances is to use a variation of the standard sp_addlinkedserver syntax and give the linked server a different name.

EG: sp_addlinkedserver 'Server_Inst', ' ', 'SQLOLEDB', 'Server\Inst'...

Thanks Frank, another one to add to the list

If you already have the server setup as a Remote Server then you'll need to give the linked server a different name.

EG If you have a server called ServerA. It...

Ok, given the small amount of records, how about running a short VBScript over the file to split it into a seperate file for each table. Once that is done...

Is this related to this task you were asking about previously?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=159272&p=3

How big is the file you're importing?

I think you'll find that a "Syntax Error" aborts the batch.

If you want to ignore the error, why not validate the data before executing the statement? Maybe something like ISDATE()...

I don't think it's to do with the outer join. Make sure you have followed Books Online exactly. If you miss even one part you won't be able to define...

What is the error you are recieving?

How about you check the glossary in Books Online. Then if you need further clarification, clearly state what you don't understand.

Better than looking at Syscomments. Use the Information_Schema views. Best bet is probably INFORMATION_SCHEMA.ROUTINES.

Although given that you're comparing object across different servers, It might be better to try one of the many...

Check the recovery model of the database that is failing. If it's set to 'simple', then you can't do transaction log backups.

As AJ has said, What features are you wanting that QA doesn't provide?

There are quite a few editors out there,

- the afforementioned ApexSQLEdit

- SQL IDE from Imceda http://www.imceda.com/SQL_IDE_Description.htm

- for...