At the end of prayer , you say COMMIT instead of Amen!

Amir

You're right somehow. I can use INT instead of TINYINT , use identity and leave gaps. I'll try the sp_executesql special feature and scoping problem in EXEC() and inform you,...

Dear Andy,

If you wanna spend more time on my problem after your coffee :), and I appreciate it so much, please concentrate on the part:

SELECT Min( SeqNO ) newLastID

...

Brian,

The events you mentioned probably rarely take palce. However, the point is that it's a central procedure and so critical. Because, it's a general proc to get last valid ID...

Here's the code :

CREATE PROC PRC_SYS_GetLastID

( @TableName sysname ,

@IDField sysname ,

@WhereClause sysname ,

@LastID sysname OUTPUT )

AS

SET @WhereClause = IsNull(@WhereClause, '')

-- Drops ##SeqTemp temp table...

Than you very much , but it didnt' work yet!

It seems SQL Server does what it likes instead of what developer tells it 🙂

Amir

Steve,

1. No , I haven't chaged the security settings.

2. Yes , they run under the same account.

Andy,

Which Service Pack do I need for SQL Server 2000 Enterprise Edition?

Anyway, thank...

Andy,

At first thank you to answer me. Then , about your question:

1. Yes , I can start it manually , without any chage in the account name and password used...