Frank,

Perhaps your IIS Admin will give you a virtual directory within a new site to access your logfiles directly. I have done this in the past with good results....

Hey ranec,

I have installed sp4 on only two boxes so far. One was a production machine that I was upgrading, the other a box that was in the process...

quote:

---

Congratulations,

I am preparing on exam 70-228, I am using MCDBA Two in One.

Any one have any better book in mind.

Thanks

---

If the users need to maintain high level rights, and you are only trying to avoid accidental drops, you could create a schemabound view on the table in question. ...

Is the SQL Server service set to run as a local or domain user?

What is your local configuration?

Are you running sql server locally? If so, are you using a full version or just the client tools?

-Dan

Try this:

******************************

ALTER DATABASE DB1

MODIFY FILE (NAME=DB1_Data, NEWNAME=DB2_Data)

******************************

Hope that works,

- Dan