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....

configure the min value to be a sensible value other than zero but not higher than max

in the interests of database\referential integrity don't re use them. As stated, if you're needing to re use the column it probably shouldnt be a PK.

you sure its not dis appearing ink LOL

backup and save your system databases first if you have already created logins, databases, etc

as Ken stated x86 is the version you require