Your only chance might be with LogExplorer by Lumigent. Depends on if the log has been overwritten/truncated yet. Wouldn't get my hopes up.

Andy

How about sp_changedbowner?

Try sp_change_users_login. I think you're just seeing an orphaned user.

Andy

I don't think that will work either. Why would you care? The reason for the alias is to "pretty" it up for display, especially if you're using a function or...

Not that I can see. Not documented as a property in BOL or in the object browser when you view via VB.

Andy

I dont think we have one posted, but that is worth having - I think we have one at work, think we got it by looking at the specs for...

I'd like to see the code if you wouldnt mind posting.

Andy

Try msdb..sysdtspackages.

Andy

How are you connecting? I tried with ADO 2.6 against SQL2000 with the following code, no problems:

Dim cn As ADODB.Connection

Set cn = New ADODB.Connection

cn.Open "Provider=SQLOLEDB.1;Password=test;Persist Security Info=True;User ID=TestUser99;Initial Catalog=master;Data Source=eg"

cn.Execute...

Have not tried it - a quick hack would be to wrap your message in HTML tags, most email clients will switch to HTML if they see a leading <...

Don't sweat it - but thanks for posting - sometimes when you're stuck and looking for an answer running across a thread like this is just the thing to get...

I don't know about the cluster, but you can probably shortcut the restore. If you stop the service and just replace the bad master.mdf with a new "blank" one, when...

Nope, it stores it as nvarchar(4000). Sucks. Doing the batch file thing will work fine. What I usually do (since VBScript ain't my favorite) is to write it in VB...

I keep all mine owned by SA - not a big deal to change even after the fact. Neatness more than substance though.

Andy

It should have worked with the single file attach - I've done this many times to quickly get rid of a huge log file (detach, delete log file, reattach). Torn...