savethytrees (12/8/2011)

---

Have you tried creating a Login for that Windows account in SQL Server? I have seen that sometimes its best to explicitly create a Login for windows account instead...

I am getting the same error listed above when trying to log into management studio with Windows authentication to administer the database instance. However if I change the server...

Thank you very much!

I apologize for not being more precise.

Gone = Not visible if someone uses a hex editor and reads the hard drive sectors?

Also,

The version of SQL Server is 2000.

Does a full backup include ghost records? When I restore to another location are they still there?

I have this same problem. I can run a script that grants execute for the stored procedure to the role, or I can manually add the permissions through the...