the white icons mean you do not have permissions on that server to manage the sql services (stop,start, etc)

dont forget to carry out the post 2005 migration tasks.

run dbcc update usage and rebuild all indexes\stats

attach the databases first as when the script is applied to add the logins it will fail as the users default database does not exist. Maybe it doesn't really matter...

tee hee hee ROTFL

undoubtedley the best way to go

awp (12/11/2008)

---

my plans are as follows:

- script all the logins from sql 2000 instance and...

the dis advantage of log shipping is that the best state you can get is read only, the database will be unavailable when log restores take place. Replication will produce...

dont forget to rebuild all the indexes afterwards too

run a repair on the .NET2 framework via add\remove programs

or just click start then run and type

odbcad32

then hit return 😉

if you use the upsizing wizard in Access it has the option to generate\configure an Access front end that you can then use to link to the SQL database

Phil Auer (12/9/2008)

---

I feel reasonably stupid but in my defense, I did clearly state that I am a 2005 novice ...

I am, however, certain that I will always remember that...

check the following key in the windows registry

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL

which button are you clicking to execute the script?

exec sp_change_users_login 'Update_One', 'Current user in DB', 'SQL login to link to'

herbiechin (12/8/2008)

---

In more or less the same situation, I am trying to restore a backup of a database that was taken in SQL Server 2000 (Instance) onto SQL Server 2005....