run some of standard reports such as memory consumption, performance total i/o

i would have them create you new box sql2008 express

restore it to that an see if that fixes the problem and the apps still work

It if works use it and...

disk space depends on how fast it is growing

100 gb growing 10 gb a month needs one number and 100 gb growing 100 mb a month needs another

if you...

are the sp pretty good size

might be compiling

not sure what you are wanting.

Depending on the amount of data being transferred you might want to go thru export wizard or ssis

but t sql would probably be quickest...

well i have had several linked queries than ran much fast in sql 2000 then in sql 2005. Several queries to seconds in 2000 and minutes to an hour...

well i use cursors alot for management reports that go across 50 servers.

so that you create the dyanmic sql for the server name and a cursor thru the servers

well if you are using 32 bit you can create an excel linked server that you and then insert into

you didnt say which one is which

but in theory as long as the domain account has rights to the secondary server. Then is should be able to create the logs...

not sure if you need to move the master database

moving to sql2008 from sql2005 isnt very difficult

the issue is there isnt any going back since you cant restore sql2008 to...

a little more imformation please

such as what type of file,how many records

microsoft changes to GMT time

One reason for that would be the notorious RBAR cursor

Since the application may be inserting the 300 rows per second one row at a time which causes the application server...

need a little to be more info for code examples

but you can setup a linked server to excel on the local drive then do normal insert into

not sure what you are looking for but you can setup alerts that will email you when you hit 80% in sql or perfmon