and dont forget to set SET @@ROWCOUNT 0 after deletion

is time out coming frequently or any particular time ?

it means there might be chances that another process(example jobs/backup) running behind the scene

vmssanthosh (3/19/2010)

But you do not have to be rude like this.. you could have just ignored his post.. thats how people starts here... At the start itself no body answers...

NO, it will give only those engineerid and engineername which are not present in table2

this query will exclude all the records/engineerid which are present in table2.

there is no duplicate values and secondly is this from table A or table B ?

it should . can you post some sample data where this query is failing ?

Sorry, I thought that the link might help you, as you can script out the users and apply them after having data refresh.

Try thisdeclare @t table ( EngineerId int )

insert into @t

select 1

union select...

Srikanth ,

can you post your script which is used in job, i guess it needs some modification

Read below post

http://support.microsoft.com/kb/246133

Go to Object Explorer details (press F7) >> click JOBs folder >> select all jobs >> right click create script for jobs

OR

Use SSIS package

why index offline holds a schema-modification lock ? please explain

another post with related problem http://www.sqlservercentral.com/Forums/Topic881805-360-1.aspx

where substring(dprtweekday, datepart(weekday, dprtdte), 1) = '1')t1

for this code Sql optimizer doesnt use index seek/clustered seek.