I adjusted all column to varchar(max) and got the same error.

I don't use SSIS, but I tried Import Wizard and ... no luck.

Here is what I've got:

Executing (Error)

Messages

Error 0xc002f210: Drop table(s) SQL Task 1: Executing the query "drop table [dbo].[ep]

"...

Hi,

Yes, I did created linked server if this is what you're asking for.

I was looking for something similar to Oracle's "Driving_site" hint to do the join on remote site.

I...

Thank you, it is close to what I wanted to achieve.

Thanks for replies,

I don't use SSIS.

Not sure if it makes sense, but I was hoping to place the check for number of rows in table A (function call below)...

You're right as I see the following values:

2 days 23:28:45 .703

-4:0-57:0-26:00-703

when running SELECT * FROM T WHERE isdate(time_column) = 0

Do you think I am receiving following message because my data is stored in nvarchar(max) column?

--------------

Msg 241, Level 16, State 1, Line 9

Conversion failed when converting date and/or time from...

Thanks for replies,

Trying to use your last solution in the query and get an error:

--------------

Msg 241, Level 16, State 1, Line 9

Conversion failed when converting date and/or time from character...

Thanks Berry and Mark,

It works now as I moved rollback to prior to the insert into error table.

It didn't work. The result: the same error.

Elliott,

Thanks for reply, but rollback is in the CATCH block.

begin

begin try

begin transaction

update fo_run_date

set fo_act_run_date = '123';-- <== this is int going into datetime field

commit transaction;

end try

begin catch

insert into perf_bench_fo_errors (proc_name,...

Thanks for reply, but ...

Nothing was logged into error table 🙁

Thanks to all.

Here is what I ended up doing:

EXEC sp_MSforeachdb

@command1 = '

IF not exists(select 1 where ''?'' in (''master'',''model'',''msdb'',''tempdb''))

EXEC [?].dbo.sp_MSforeachtable

@command1 = ''INSERT INTO #Tables EXEC sp_spaceused2 ''''&'''''',

@replacechar = ''&''

'

Eugene

so it only needs to exist in master?

because at the moment it's in master and in one of other d/bs

use [master]

go

select *

from sys.objects

where name = 'sp_spaceused2'

Thanks for reply, but I am getting the following error:

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'sp_spaceused2'.

declare @cmd nvarchar(100)

declare @db_name varchar(128)

declare db_cursor cursor for

select...