did you change sqlserver service accounts ?

Indeed it says "Design Table" (There is no identity-property on views ! )

Then select the column you want to autoincrement.

In the column...

Don't delete your jobs, you will loose their history.

Here's a...

AFAIK the only db-level for SQL2005 to support are 70, 80 and 90.

Try the SQL2005 Upgrade Advisor to check your database.

You may even want to download sqlserver 2005 express edition...

How about using EXEC master..xp_logininfo @acctname = 'youruseraccount',@option = 'all'

let's just save time ....

In our company, Week no 1 is the week wich contains January 4-th.

I've implemented these UDFs :

Maybe this gets...

Maybe you could start with http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

I don't know if there is a "emulate standard edition" switch

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...