April 4, 2008 at 9:19 am
I was copying a database from production to dev, and accidentally copied all the logins (not enough coffee!). There are now hundreds of logins in development that we do not want to have access therein. I have a decent script for removing logins by login name, so if someone has a good way to generate a list of logins by date created I can fix this easily.
April 4, 2008 at 9:30 am
There's a createdate in the syslogins table. You can use that to get a list of names.
April 4, 2008 at 10:11 am
Geez, that was simple. And what bothers me is as soon as I read your post I thought 'I knew that!' I was in too much of a hurry to fix it before my boss had a fit (oh, and he would) and I wasn't thinking clearly. Thanks for the help. 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply