... One other issue that might be a factor is that at the moment all our databases are set to a compatibility of 80 rather than 90. This is the...

..domain admin ? No reason at all !

It doesn't even have to be local admin on the box ! The one installing sqlserver needs to be member of the...

topic "Moving System Databases" in BOL describes it clearly.

When I find some time I'll have to test this procedure myself. (this will be after 3 weeks because I'll have...

- So you moved the systemdb's and the RTM still worked ?

- what are your startup parameters for sqlserver ?

- check the original locations to see if sp1 put new...

that's one of the things they did not alter for sql2005.

You still have to mention the filegroup for each index and there is no setable default (other then the normal...

A default instance for sql2000 uses the reserved name MSSQLSERVER;

If you stated MSSQLSERVER for your named instance, you may be in troubles !

Be specific and mention the names you've used.

maybe this will help out ....

I don't have the ref where I got it

CREATE TABLE #tables_usage (

    name varchar(50) NULL,

    rows varchar(15)...

here's a very good article ...

http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

use yourdb

exec sp_helpfile

you may want to add following startup-parameters to your sqlserver so you get a glimp regarding deadlocks...

-T1204

-T3605

to activate this without stop/start :

--dynamisch activeren

 dbcc traceon(1204, 3605, -1)

but add the...

- also upgrade to sp4.

- what kind of connections did you allow for sqlserver

  (sqlserver serverproperties network-config)

...Not that I expect that anyone would run out of drive letters...

- consider a cluster-node with a couple of instances topology driv1-data1 drive2-data2 drive3-log drive4-backup .... You'll run out of...

If you want the identities to start using your specific startvalue, you should specify it when adding the identity-column. Not afterward with a checkident !

Check books online !

regarding the reseed,...

or direcly

ALTER TABLE UsersImport ADD userIdInt int IDENTITY (99,1)

or build the alter dymamic :

declare @stmt varchar(4000)

select @stmt="ALTER TABLE UsersImport ADD userIdInt int IDENTITY (" + convert(varchar(15),@yourvar) + ',1)"

exec (@stmt)

No problem

SQLServer publishes itself !

If you don't change the servername, there is no problem.

IPaddress changeing is no problem, as long as your applications do not connect directly using the IPaddress...