looks like setting the error output for the column to 'ignore failure' does the trick. not so elegant though.

any better ways?

i'm looking at my sql 2005, and it's listed where i said it was.

sp_execute is listed under 'Extended Stored Procedures' -> 'System Extended Stored Procedures' in SQL 2005

hi, I'm experiencing the same problem.

Is there a way around this?, I need to 'insert' then do a 'select' inside a function.

thanks

Thanks Jason, this will come in handy for me soon

i was just digging around as per usual, didn't really pay attention to the date of the thread.

but it's cool. i've managed a work around for the errors i was...

ok, I got a solution of some sort.

I did not inlcude those fields that's giving a convesrion error in the insert statement. I just run a separte Update query and...

hate to say it, but I'm in the same situation.

Anyone have any further thoughts on this?

thanks

Hi, thanks for responding. I was assured that there are no ';' as part of the value. it's only used to separate the array field.

Hi Ian,

Can you be more specific?. I'm trying to do the same thing.

Thanks.

Roshec

anyone?

I'm in the same boat.

great, thanks, I'll edit my scripts.

Hi Jen,

Would you mind posting your resolution on this issue?

I'm in the midst setting up transactional replication (SQL 200 Standard Edition) and I might encounter the same problem.

Thanks!

Hi All,

Just want to close this issue. I've since realized that what I'm trying to do isn't possible, (trying to suppress error)

Thanks anyway.

Hi David,

What can you say about this article?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp

It says...

"When you execute a DBCC SHRINKFILE statement SQL Server 2000 fills the remaining part of virtual log with dummy records"