make that column an identity column.

Enterprise manager\yourserver\yourdatabase\tables\yourtable rightclick and edit.

Select the column and add the identity property.

Litle remark. When you enable the identity, you're nolonger alowed to use that column...

Don't use the AWE because you don't have > 8Gb RAM.

Adding the /3Gb is enough.

Check out http://www.sql-server-performance.com/sql_server_performance_audit5.asp

declare @Serveradmin int

Select @Serveradmin =  IS_SRVROLEMEMBER ( 'sysadmin')

print @Serveradmin

if you want to do this using SQLServer you can use xp_fixeddrives to see how much space is left on each (local) drive.

Create table #tmpDrives (Drive char(1), MBFree int)

insert into...

It's not exactly what I was searching for, but maybe I'll comeup with it later :

- http://www.sql-server-performance.com/reducing_locks.asp

- http://www.sql-server-performance.com/sf_block_prevention.asp

- http://support.microsoft.com/kb/q193095/

I was aware of the concept you had in mind , but I don't think this is implemented in sql2005.

I think Windows WLM...

This is the same debatecontext like for NULLs.

OK, DRI is a pain in the but for developers, but it guarantees some data related...

in addition to PW 's reply ...

is the create table for the temptb also within this transaction ?

I've read about this situation...

how recent are your statistics ?

run sp_updatestats and dbcc updateusage ('yourdb') with count_rows.

This may interfere with ongoing operations !

Then check your...

just a wilde shot ...

The hostname is determinde by data from the connection string.

What's the application name that's shown ?

In case of excell...

It might make sence to run sp_updatestats and dbcc updateusage(0) with count_rows manualy. This may interfere with ongoing operations !

Then try your procedure again

If your applications connect using the IP-address there will be no problem.

just be sure to follow this: http://www.databasejournal.com/scripts/article.php/1496451

and...

just my 2ct.

in addition to PW's and Strommy 's replies :

Your cluster-instance must have the new...

take a look at http://www.sqlservercentral.com/scripts/contributions/592.asp

imo if you allocate a drive letter (net use z) , you should also unallocate it (net use z /delete).

Unless offcourse this is an action that would be performed very often.

Then...