should be doable.

may I emphasize you need to start with SQLServer upgrade advisor.

It checks your sql2000 sb/server and will highlight issues you need to address before the move !

also keep...

yep

because EM will present you the old file-locations for all non-mdf files.

(if gets...

there is a function documented at

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

if the clustering index key(s) is not unique , sqlserver will make it unique for you (by adding kind of guid).

All access to the datapages for a clustered table uses...

just a first glimps for a simple start

This select shows the values from within the same table...

Concept may be a good start..

select T1.[object_id], T1.[date], T1.data1 as T1_Data1, T1.data2 as T1_Data2

,...

Books online explains this very well !

The clustered index actually has the data in its leaf level !

A NCI is built aside from the table, based on the table and...

This prooves once again the world is round :w00t:

actually your full sp might be replaced by one dts package.

If you don't need things to be synchronized online-realtime, switch to DTS !

there is a DMV exposing this in sql2005, I'll have to do a little search on it.

this comes from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2892190&SiteID=1

(I don't have my own scripts available for the moment)

-- CREATE...

you can use DTS for this.

from EM in the table pane rightclick and select import/export data....

You can save the package and schedule it if needed.

Don't swap schema.

Just create a

create view dbo.myview

as

select a.col1, b.col1, ...

from dbo.table1 a

inner join dbo.table2 b

on a.key = b.fk4a

- if you add with check it checks the results of...

I knew your name did ring a bell 😀

the SSC-article http://www.sqlservercentral.com/articles/News/exceptionhandlinginsqlserver2005/2237/

introduces try-catch.

but I got to admit I like your art. more because it goes more in detail and has...

SQLserver only has a precision +-3ms

IMO if you'd enabled database owner chaining, things might have worked from the start on.

Post your clr-code and you have a good enough chance Jeff or someone else comes up...