what does

exec sp_spaceused 'transactions'

produce

Mani (2/23/2009)

---

Hi,

Iam using the below script to rebuild/reorganize the indexes in sql server 2005. Iam running this script manually every week by going into each database. But I want create...

so your sql2000 instance is currently clustered is it?

you could import as legacy but if moving to sql2005 why not re write the package in SSIS

read the MS recommendations.

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

certainly no larger than 1GB should be required but recommended is 512MB

the biggest problem is setting the shared storage and this is what i think most people stumble on. The storage can only be accessed by one VM at a time...

Anybody?

yes it would do, you dont need to give db_datareader and it...

personally i would use

1. Backup the databases in Sql server 2000.

2. Script the logins,jobs in sql 2000

3. Install sql server 2005, SP3, sqlserver2005_dts.msi

4. Restore the backups in newly installed sql...

granting execute on a stored procedure to a user does...

drop the auto created stats from the sql2000 prod database, otherwise each time you restore that db the corrupted object will still be there,

does this make sense

Kendal i too, did notice the graphs were a little off but paid more attention to the actual numbers

Matt Klein (2/19/2009)

---

I see, thank you. Our box is 2 quad cores with 8 gig of RAM. So is there any reason for us to go to...

either backup and restore or detach and attach to the new server. Script off the login if possible or create a new server login on the sql 2005 server and...

depends what you're going to need. Windows 2003 Std x64 bit is limited to 32GB RAM and 4 cpus.