I'm starting to suspect that the issue is with something you have not told us about. It would not be the first that this happens in a forum thread....

But you...

If you run

CREATE TABLE #temp(a int NOT NULL)
INSERT #temp(a) 
   SELECT a FROM OPENQUERY(LLIVE1, 'SELECT 1 FROM dual UNION ALL SELECT 1 FROM dual UNION...

What happens if you run the SELECT on its own? What happens if you insert into a local table?

And I can't escape wondering how come you are not running this...

• This reply was modified 5 years, 10 months ago by Erland Sommarskog. Reason: Typo

I would use Profiler to see what is going on. Run it on both machines, and make sure that you include the events Error:Exception and Error:UserMessage. Also include SP:StmtStarting and...

Connections to SQL 2005 from SSMS 18 is not officially supported, but as long as you are only using query windows it should work. If you use GUI dialogs you...

This is what Scott had in mind:

CREATE UNIQUE INDEX my_index ON tbl(col) WHERE col IS NOT NULL

Although, with an INSTEAD OF trigger, the column can be made NOT NULL, which...

I created this procedure in tempdb:

CREATE OR ALTER PROCEDURE slafs_sp @time time(0) AS
   SELECT * FROM sys.objects WHERE convert(time(0), modify_date) <= @time

set...

It would be better to paste the code for the script, using the insert/edit code sample button rather than posting a picture. That would also permit you hide your sa...

So how does your script actually look like?

As always when you call a procedure, you put the parameter value after the stored procedure. For instance:

et DBName=DBLive

set DBServerName=ServerLive

set FileName=ClosePrice_N.csv

set param="My parameter value"

bcp "EXEC %DBName%..stp '%param%'"...

You mean it tries to insert all the rows at once, and only AFTER they are all inserted, does the trigger begin its work?

Yes.

I can't say whether it is a...

Yeah, but the trigger is an AFTER trigger. So the trigger does not fail on multi-row inserts. The INSERT statement fails before the trigger is fired. This is why I...

Not sure that I get this, but if you insert multiple rows at the time, and don't fill something in the CompleteTaxonText column, you have multiple NULL which will validate...

In the Advanced tab for the job step, specify an output file for the job step. That is better than the job history which has a limit in number of...

It's nchar(10), so why only seven?

Anyway:

UPDATE tbl
SET    rec_ref = replace(str(rec_ref_to_date, 7), ' ', '0')

The str function returns a number right-justified padded by spaces. Default...