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

there is a stored procedure you can use to get all the tablenames in hierarchy order.

here's an example:

create table #tuser (type int, oname varchar(517), owner varchar(517), seq int)

insert #tuser exec...

you can do it in a single with something like this:

declare @somekey int

set @somekey=1

if exists(select * from ItemTableOne  where someval=@somekey)

select * from ItemTableOne  where someval=@somekey

else

select...

nothing predefined, but you can easily take Tyson's example and create a stored proc witht eh same code.

if you change a .config file or .aspx, no recompilation is needed. if you change a .vb file, then yess you have to recompile.

i'm guessing table joining and reserved word issues here?

does this look a little better?

SELECT ICDCODE FROM DIAGS

INNER JOIN [PROCEDURE] ON  DIAGS.DIAGID = Procedure.DIAGID

i think the issue is permissions. the user running the app does not have write permissions to HKey LocalMachine;

When you type in an instance in the SQL manager, it tries...

I think something like this will work for you:

CREATE TRIGGER InsPeriods ON dbo.table2

FOR INSERT

AS

insert into dbo.table3 (itemID, installment, periodvalue, paymentdate)

select

  INSERTED.itemID,

  INSERTED.installment,

  --avoid division by zero or...

there's no good reason to limit yourself to 8 characters on the name of the database. just because that was the limit in older systems, doesn't mean you should handicap...

who owns the data? doesn't the company you deploy to own the data in the database?

We have a very similar situation...we provide a blank database with default values, and...