If the procedure in in the Master database, name it starting with sp_ and it can be called from any database on the server and will run in local database...

Ok, you are not paying attention. The column is a numeric data type, so the =="" part of the expression is not needed. In my post at 8:30...

Like I said, the SchemeID=="" part needs to be removed because the variable is numeric and therefore cannot be empty string.

As far as the expression:

ISNULL(SchemeID) || SchemeID==""

The ISNULL...

Then it cannot be an empty string, so you just want:

ISNULL(SchemeID)

True, but as a database professional, I get nervous about features that tend to allow for a poor database design. This is one of them.

Not to say MS SQL...

Yes, it is possible. I would not typically recommend it.

A trigger is part of the original transaction. So, if your linked server is down or you have a...

Without seeing the error or the package, it is hard to tell.

You probably have a data type issue though.

If SchemeID is a string:

ISNULL(SchemeID) || SchemeID==""

Also - be sure...

I don't know about being a shame. That is one of the features in Oracle that is both a blessing and a curse. In most cases, I think...

I would recommend using the system stored procedure sp_who or sp_who2. If you create a temp table, you can insert the results of the procedure into the temp table...

No, MS SQL does not have deferred constraints like Oracle does.

I usually stay away from doing this. There is no way to be 100%. People are sensitive about their names.

Sorry to say, it's not a horrible temporary solution. I am not a big fan of using MS Access for any production system, but as a migration strategy, creating...

The optimizer MAY materialize a view if that will generate what it thinks is the best performance. Of course, the optimizer may do this with any part of a...

Yes, turn it back off when you are done.

You are still not specifying a column list.

Your insert shoud look something like this:

[font="Courier New"]INSERT INTO tblDistributors (MyCol1, MyCol2, MyCol3...)

VALUES ('AlabamaZinc', 'PT', 'OUT-XCS', 'Inbound', '1','LS','1','2','0','2040','8999','0', '','0','0','1')[/font]