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

I hope you are not trying to run this on a cluster ?

Why don't you generate the osql-line in your job and then xp_cmdshell it ?

(select @sqlcmd = 'osql -E...

- are you sure nobody changed the tablestructure when you were looking at it with EM ? (You will need to refresh the tables-tab) Refreshing at the correct position in...

Whichever way you're going to do this delete-cycle. Remember to provide the propre indexes (FK) to speed it up ! Keep their columns in exact column-order(as defined on the parent-table).

...