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...

here's noeld's script witht he username pulled out as a parameter:in my example the username is 'hds'; i don't know how this will work for NT logins.

declare @cmd varchar(300)

declare...

you've got to look at the vb6 code; the issue is that you are referencing an object that hasn't been initialized; for example, if you create an ADODB.Connection but forgot...

here's an idea pending better definition of the WHERE statement: note that everything would be in foreign key hierachy as described previously.

this assumes that the foreign key column name is...

i've got a decent idea how to do this, but what is your filter criteria?

i assume it is sometable.columname in(1,2,3) or sometable.columname  < 3000 or something, and you want to...

the DDL helps a lot, in this case i think i'd need row values to extrapolate this correctly.

i think this group by statement would give you the question as well...

error trapping in TSQL is pretty limited;

if an error is level 16 or above(foreign key constraint violations, primary key, etc), they raise an error that cannot be trapped in TSQL,...