my bad;  in the rush to post, it's the wrong procname

sp_recompile is the correct name;

yes, it will get the next value; here's an example:

create table #tmp (tmpid int identity(1,1) not null primary key,tmptext varchar(30) )

insert into #tmp(tmptext) values('SQL')

insert into #tmp(tmptext) values('SERVER')

insert into #tmp(tmptext) values('ROCKS')

set...

this should really be handled by a programming language and not SQL server.

it's very easy, maybe 15 lines of code to loop thru a recordset and save the image to...

you might want to consider adding a constraint to prevent the data from getting messed up in the future too:

alter table sometable add constraint UQ_Custnbr_Email unique(Custnbr,  Email)

you'd have to add...

like Ken said, if the error is level 16 or above, (foreign key constraint,unique constraint, primary key for example) it cannot be capture via TSQL.

use a different style of logic...

i recently had a view that gave different column definitions that if i ran the select portion of the view from getting the select via SP_HELPTEXT viewname.

as a result, i...

perfect; that's why i love the forums here; somewhere, sometime, someone must have fixed a problem someone else is going to get;

way to go!

you still need to use DTS, but instead of selecting a table, you can choose the second option "Use a query to specify the data to transfer"

in my example, i...