try right click, refresh. EM is notorious for not refreshing information.

I looked on EM and a couple needed to refresh to show the status.

It's describing creating a domain user account for the sql server to use as its service account. ( same as a domain account you'd use yourself but for sql server...

I think in an ideal world you've just about hit it on the head and tied in with security permissions on the file system would be good.

However, real world often...

They actually do different things, I always do both after index rebuilding, just to be sure. It's never hurt my databases. dbcc updateusage is quite hotly debated, I always figure...

It's possible you need to visit the surface config settings.

There are a couple of points on seperating tempdb which I find are often overlooked .. this is only really relevent where tempdb is very heavily used.

First if you don't...

I'm quite happy for the use of varchar(max) and including them within index defs - these features will help keep me in employment < grin >

I seem to remember sp_depends wasn't too good. Nothing beats documentation at the design and implementation stage < grin >

have a look at the query plan, with an index I would have thought maybe 3 i/o per OR statement .. even though it's one column it should work as...

get hold of robocopy ( from the windows resource kit ) and use xp_cmdshell to create the cmd line to do the file copy.

If it's on/behind  a web site you need a per proc license. Your app might use sql express which is free so check that out.

renaming objects can create all sorts of problems, like you're seeing, I'd really suggest that to be safe you drop and recreate  ( with a copy for data ) rather...

do you mean you re-installed 32bit and 64 bit on the same hardware for each test? 

Is this an amd or intel box?

have you been renaming objects ?

You may have model highlighted in MS .. try right click create database on the database instead.