Did you run a maint task? DBCC, rebuild indexes? If it was just on one db I'd suspect you have a job running some place that does a lot of...

Steve's list is good, I'll just add this - if you use the Maint Wizard and take advantage of its options, you'll be in good shape. From a pure DBA...

I was thinking that this was used to store diagrams - maybe Im confused? And I think remember hearing that it was a user table because of some kind of...

How are you deleting, from the EM view pane, or with a TSQL delete statement?

So far I believe not.

Andy

There is a DTS task to do this in SQL2000 I think. The data is in sysxlogins, you can bcp it over, or use sp_addlogin. Be sure to check for...

There is a codepage property and setcodepage method, both belonging to the DMO Server object.

Andy

SP_oa and the rest are useful, but only in very limited circumstances I think. Why did you decide to code it yourself vs openxml?

Andy

Depends on what you call execution. For example, if you create a temp table in Query Analyzer it will exist until you drop it explicitly or you close the window...

Drop the 'new' database you created, then just try doing a restore - specify the dbname when you restore.

Andy

Have you researched the code from the event log? Can you start the agent manually once the SQL Service starts? You should check the account name and password used for...

Well, did you find any additional info in the errorlog? Have you got Outlook 2000 set up and working as a standalone app on the server? Good first step is...

The sp_spaceused method will work as long as you have a valid login. DMO is not just for servers, I havent had time to figure out if there is a...

One way to start it would be to use xp_cmdshell to run 'net start sqlagent', where sqlagent is the name of the service (different for different instances). You can also...

Yes,pretty much, as long as you're using it without a UI (although come to think of it I dont know what would happen if your dll DID have a UI...