That adds a user, but doesn't allow a login to the server, because there's no login defined on a server level.

Here's what I did: Added an Active Directory account...

Amazingly enough, I don't see too many of "select all" in applications.

I kind of have a strange desire to take on that project:) maybe, because I don't like useless...

Bob Hovious (2/10/2009)

---

This is why I think interview questions should just go unanswered, even deleted. There's no telling how much damage is done to companies that are...

I understand. Makes you think you've accomplished something! At least I did when I finally got to the end of the thread. (Took me about 4 days...

I can't believe I just read all 122 pages of this thread!

Anyway, just wanted to point out...

winash (2/5/2009)

---

If you are looking for columns that are not used by your application - and assuming that your application uses stored procedures/functions/views to access data - you can parse...

I wish it was as easy as identifying empty columns:) No, it's basically one big read-only database that is used by different applications. Data gets populated every night, and I'm...