quote:

---

If this login still needs access to the server to run a sibgle stored procedure, what can I can to implement that...

By default, SQL Server errorlogs are created in folder \mssql\logs that could be in one of your drivers.

You can find it by open server properties --> startup parameters -->...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=18034&FORUM_ID=5&CAT_ID=1&Topic_Title=Local+%3D%3D%3D%3E+Domain+User+Account&Forum_Title=Administration

quote:

---

I have created a domain account called flex_sql on 001 and login to machine under this account. flex_sql is an administrator...

Do you have 'BUILTIN\Administrators' login in your SQL Server? Are they in local administrators group in your server? Check login column of sp_who2 to see what login id they use...

Try sp_denylogin to this NT Login in SQL Serevr.

Run dbcc dbreindex and sp_spaceused @updateusage = true to both databases and compare the result back to see there is still a difference.

There must be 'guest' user in your databases. If you do have it, remove it from user database but not from master and tempdb. Document what you are going to...

You have to wait the rollback to complete. Force SQL Server Agent to stop to kill the rollback process could cause protential database integrity issues.

Once you install Virtual SQL Server, It will create SQL Server cluster group. You need to add these SAN drivers as disks resources into SQL Server cluster group and configure...

What databases are you tring to hide? As long as you don't grant the user to access the database, the database will not appear in the object browser. One...

You should run sp_spaceused @updateusage = true or DBCC UPDATEUSAGE and go back EM to check.

Agreed with Steve, Why don't ask your hardware vendor?

You need grant his login to access master database and 'select' permission to 'syslogins' table.