I don't know if this is the cause but SP2 prior to March 7 requires a patch due to issues in the Maintenance Plans. I think the patch was rolled into...

One more thing, EM uses tempdb for this so if tempdb is extremely busy, timeouts will occur.

The Ole Automation SPs are actually XPs (DLLs) and require that the user be in the sysadmin role. I don't think that granting execute privileges on them will alter that....

I just found this on the MSDN forums:

"The functionality to view remote tables/views for linked servers is not available in SQL2005 Management Studio. You can use the system stored...

Yet another useful feature that Microsoft removed. I haven't found a way around this either.

I just found sys.all_views which is probably better for your purposes rather than sys.all_objects

I haven't tried this,  but the 'sys' and 'INFORMATION_SCHEMA' schema_id numbers are 3 and 4 respectively, so you might try somthing like this, paste the output into another query and run...

OOPs -that should have been SQL2K5 Standard Edition

SQL2K5 can address whatever the operating system maximum is. If you have more than 4GB of memory it's a good idea to use 2GB...

sorry - Access Control List. Yes, it is permission talk.

If you don't want to delete the folder (I imagine that would be for a "just in case"), change the ACL to allow only your login to access it and...

I don't know if SP2 will make grants easier but Maintenance Plans have been added to SSMS that will have a similar look and functionality to EM

Hit the button too soon. I wanted to add that there are lot of people that feel the same wa and that is what makes this such a successful site!

Once...

I'd like to add my congratulations and my thanks (plus one more post )

Without a doubt, I get the most help for SQL...

"technology is maturing"

You have no idea! Everyone seems to have forgotten (or didn't know) that there is language out there that has been using multidimensional arrays for over 20 years...