Posted by Oscar Santiesteban on 10/21/06 14:11

I have "detached" the database on SQL 2000 and "re-attached" on SQL 2005
with no problems. You have to create the user logins and do the
sp_change_users_login.

<rc@!die!.spammer.bhfshops.org.uk> wrote in message
news:5rccj217fl7r2g5ijhh4hj4ha0nb308uvo@4ax.com...
> Hi
>
> We are going to upgrade from SQL 2002 to 2005. We have approx. 100m
> rows of data on the main table and hand of stored procs and views.
>
> What we had in mind was that we would dts the data out, script the
> stored procs and view out and import the it back into SQL 2005.
>
> Is there smarter way of doing this?
> The key thing is that the data must be clean
>
> Thanks

[Back to original message]