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.

1434 udp is only required if not connecting to the named instance directly and usually if the instance is using the non standard port 1433

are all the datafiles in separate filegroups?

Great blog Kendal (you have way too much time on your hands 😀 )

very informative

filter out tempdb objects too

Mike Levan (2/18/2009)

---

Jack

If you want notifications you can do the DDL triggers or you could do a job that queries the default trace on a regular basis which sends you...

Jack

did you mean to specify column I.StartTime twice?

works for me, double check what you copied and pasted

Magy

sounds like the best advice is check what machine backup software you currently use. Check if there is an open file agent, if so trawl through your recent tapes looking...

dude

substitute

exec sp_ExecuteSql @sqlstr

for

Print @sqlstr

and post the output

at a guess your login credentials dont allow you to install the software, group\local policy in force maybe?