I'm glad this script inspired you today!

Here's a question for you. Have you executed my script? It only reports on SQL authenticated user accounts. So you would not get...

Windows authentication information is supplied by active directory. You should talk to your network administrators to get the...

Hello Ryan,

Thanks for the update. Guess I didn't think of this when I wrote the script as I have not seen anyone using the "." in the login name.

Thanks,

Rudy

ryan.hobbs (4/29/2011)

---

Rudy,

First...

thorkw (4/21/2011)

---

@Rudy: Sorry, but I can't find an answer to my question above, in BOL.

When do the numbers get reset, on a stop/start of Sql Server? or a reboot...

The results are display on the screen once you execute the stored procedure.

Thanks,

Rudy

Hello Everyone,

Just wanted to comment on the security aspect of this article.

The only purpose of this article is to help DBA's to get into a SQL server that the access...

If you cannot connect because the error msg is stating that there is already a connection, then you have to first see what application is still running and stop it...

I'm using LiteSpeed and have seen this before. In our case, it was simple because another backup job was running at the same time. Someone else created the same job...

Yes, this is scary and I can' think of any other way to provide a safer back door. If you have ever worked on a SQL server who's DBA was...

Good point. I think this will correct the problem you are having.

Rudy

I think you need to be part of the domain administrator's group. Check with your network team to see if they can add you until you have connected.

Hope this helps,

Rudy

Bill Stutters (3/11/2011)

---

SQL Server is 2005. All SQL default services were shut down and then SQL restarted with -m. There are other SQL instances running on the server. The error...

Are you sure the server is in single user mode? What version of SQL server are you using?

No sure why you cannot connect.

Rudy

Thanks for the info and I'll see what has happened to the images.

Rudy

Just goes to show how there are many ways to get the same job done.

Thanks for your comments,

Rudy