- SQL2000 ?  (sql7 has more pitfalls)

- If you only want to move user-db, you might consider to use the copy-database-wizard. This will have unavailability of the db at the...

there is migration-software on the marked. I just cannot recall the providers company-name.

The where present at last years PASS-conference in Seattle.

You will have to alter the object-owner !

this may help out :

Select  'print '' object : ' + u.name + '.' + o.name  + ''' '  + char(13) + ' go...

- keep in mind that sql also has to manage rowlayout, nullable columns also have the need for management-place (1 byte per 7 nullable columns). Check "dbcc showcontig" for your...

Every time sqlserver starts (or starts a db) it will check if data is consistent.

If it detects there were running transactions at...

sysdepends may give you the inventory.

sp_refreshview @viewname =  'viewname'  may perform what you are looking for

- Because your goal is to move the db to a new server and postpone application-adaption, maybe you can consider to move the db's and at the old location only...

When reindexing put your recovery model to bulk-logged or your log will grow by the size of the rebuild data..

But don't let this discourage...

alter database myowndb set offline with ROLLBACK IMMEDIATE  will do the job

- your execution plan will clarify this

- as always " it depends "

  * wich type of join are you using (inner /left-right...

rule n° 1 on every rdbms : tell your engine what you know

my 2ct

I suppose you've already checked :

- http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

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

- http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/4/

- use perfmon to check on your I/O activity

- SQL92-standard adaption.

- access-engine is not sqlserver-engine

- maybe it's on the wishlist for sql2k5

select col1 + col1 as expr1, (col1 + col1 )* 2 as twice_expr1

from a_table

did you look at BOL for CHECKSUM ?