Weird, but it worked!

I created a new standard login, changed the owner to that then back to SA and everything shows the owner properly.

Thanks for all the responses. I...

Sorry but disconnecting and re-connecting was one of the first things I did. I still get the same problem.

I even tried it again today (after a weekend)...

SQL 2000 Standard Edition, SP3 (8.00.679)

I already ran the sp_changedbowner. I did this when I found the DOMAIN\username owner. I wanted it changed to SA so I ran:

exec sp_changedbowner 'sa'

When I look in...

Thanks for your help, but now I have some questions about exactly what you are showing me.

One, in the EXEC sp_addlinkedserver command, do I run the command just as you...

I agree, I would like to avoid this BUT this database is for a third-party product that does not have the proper application security built into it and this request,...

To make the UNC notation work, you need to run:

DBCC TRACEON(1807)

This allows the SQL Server to understand the UNC notation.

We run our backups to an NAS device and it works...

Thanks guys but still no go. I had read most of the links you gave me but right now I'm going to step back from it, take a break,...

The SQL Server Agent service account IS the same account as the Outlook account.

I found the answer to my 10 minute delay. There is a setting in Outlook that...

quote:

---

Have you checked into the package object to see if you is some method that might be useful.

Gregory Larsen, DBA

If you looking...

Sorry if I didn't make myself clear. I am using a DOMAIN account. My question is:

Should I make this DOMAIN account part of the local Administrators group on...

Thanks for the reply but we have decided to NOT make the SQL Server Service account a member of the Local Administrators group. We decided this after much research...

The NAS device shows 416 GB.

SSteefel, you are correct, and I have already done this, but the security setup must be configured properly also. (See my last message at 7:24 on 10/17.) By...

Thanks for all the replies. I have already done the things that some of you mentioned. Some of the suggestions goes against what we are trying to do.

liyaka,...