Does the account running SQL have access to the remote drive?

Nope. Not that I've ever experienced...

Can't say I've had to try this so I don't really know ... tried to search a bit for ya, and I found your same post on four different sites....

None of these are necessary, but can't hurt and help to ensure all is well ...

DBCC CHECKDB (DBName)

Rebuild Indexes (don't know much about FTI, sorry) - this should also update...

Well ... you never need an additional log file, but multiple data files can yield performance boosts depending on implementation. Regardless, you do not want to go deleting them without...

You can also use WMI counters per server and log locally or push to another server ... similar concept as above, and probably easier.

Check out [sys].[dm_os_performance_counters]

In a nutshell, this is how I do it ...

I have an admin database on all my servers, but I have one central admin database "a database that controls them...

Fixed the problem. sys.dm_db_index_usage_stats doesn't get populated with the index information until the index is accessed in some fashion. Changed from an inner join to a left outer join.

Re uploaded...

MANU, you are right ... this does not appear to work with the adventureworks database. Very very odd as I do not see a problem with any other database I've...

hmmm, that is very odd ... for every database I've run it for, I have the correct amount of returns ... I have not used the adventureworks database, but I'll...

Well, that's still only one...

Is the linked server setup using integrated or SQL authentication? Regardless, does the account have access to said objects?

Did ya try http://www.google.com?

Dinu E Anastasiu (9/3/2008)

---

Thank you very much Adam.

What's interesting is that the update has been downloaded recently by Automatic Updates :angry:.

Of course I would like to install SSIS SP2 but...

Anything worthwhile in the error log (sp_readderrorlog)?