Are you moving sql 2000 db to sql 2005.

If so just do backup and restore....no need to do system databases they are different in SQL 2005.

Just go get the sp_help_revlogin...

Ok so it is a job that is in house that you created and by the time it ends it is 100 GIG in tempdb.

You may have to issue some...

Ok so if you bounce server it goes back down to say 1024 in size.

Then you run the query and voila your back up to 100 GIG

What is this...

Hmm not seen that before. Can you shutdown server it will rebuild tempdb with correct sizes.

Or if you can shrink in smaller bits.

Interesting:

Full BACKUP

LOG every 15 minutes

DIFF ...

Set up a sql login on servera and serverb with full sa rights and then use this login in the linked server...click on linked server and right click linked server...

how about some screen shots and did you try a sql login to see if that at least works.

Thanks gila - i do some monitoring. I turned in on now and keep eye on the query being executed to ensure they are using the indexes and not...

One last thing now that im back on statistics....Do you do the auto sync for your tempdb, distribution tables. (I never know if to run update statistis) on these system...

What report do you run to get the tables with the out of stats on them.

Cheers.

Thanks i have to keep mental note set it up like linked server even better.

Once a week...i run it.

It was first when we went to SQL 2005 i had it set on ..i may review this again and see. I did recall doing...

That thread and the way to get the time of the deleted object is very good ..... i wouldn't have thought to go read the TRACE file.....i might give that...

Thanks i thought that was the procedure ......i just checking that it stayed in my memory bank.

Can you explain a little more gila...

Do you mean why do you turn it off on the database....the option of the auto update statistics asynchronously

We turn ours off because with...