"It returns the computer name on which the command runs. Why are you asking?"

to start on the quest for "why isn't this working".

"So basically I'm guessing no environment variables...

- can you define "last" ?

does your table Test_Results contain a column with datetime of registration ?

- can you post both tables DDL ?

Edited by - alzdba on 12/30/2003 ...

- which Recovery-model did you specify on your sql2000 db ?

Maybe switching to bulk-logged may help out.

Edited by - alzdba on 12/30/2003 01:24:52 AM

keep in mind that rebuild index will not affect your datapages, unless you have specified a clustered index. (there should be one "by default dba behaviour" for every table )

Also...

"as part of the invoicenumber" ?

Is your invoicenumber still numeric ?

Is this to-be-generated-sequence-number used as a suffix to a fixed prefix (e.g. yearmonth&sequencenumber) ?

maybe this can help out :

You would...

proposition:

4 stars = SQLSir

5 stars = SQLKnight/SQLord

6 stars = SQLSaint

I guess an indication based on # of accepted responses might be preferable over a "rating" but...

What is it returning when you schedule a job (owned by sa) which runs TSQL:

exec xp_cmdshell 'echo %computername%'

you could try to figure out what's going on using profiler.

Check the T-sql ExecPreparedSQL, PrepareSQL.

I don't know if there is a way to pull this info straight forward from a...

create table #tmp1 (SeqNo int not null identity(1,1) ,col1 int, col2 varchar(125))

go

set nocount on

insert into #tmp1 (col1,col2) values(1, 'Abc')

go

insert into #tmp1 (col1,col2) values(1, 'xyz')

go

insert into #tmp1 (col1,col2) values(1, 'PQr')

go

insert into...

To avoid sqlstatement-length you might consider to use text or ntext datatype for the SQLstmt-column, because when your trigger fails, your transaction fails, so your applications will be affected.

Glad I...

Now the stars point to a participation level. Don't give me a AAA-rating, because all I provide is an option, to the best in my responcetime(frame) and mondaymorning-feeling.

From what I've...

This may get messy but I'll give it a shot.

TEST-it TEST-it TEST-it and use it wizely.

It's still Monday-AM

(don't know if I would use this way in...

are you just trying to use Profiler for troubleshooting or do you want to know at all time which action(s) take place on this table ?

Regarding the sqlserver-table-triggers you could...

if you can live with gaps in these numbers you could use an identity field (check BOL)

You can retrieve the inserted value afterward with SCOPE_IDENTITY()

- you could log it using triggers