I think you are looking for

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

Nice. Now how about if I have two columns

InvoiceNumber, BillName, BillDate

1, Amit , 1/1/1900

2,Amit, 1/2/1901

and looking for output as

1 ...

I have just install SQl 2008 and I do not see a resource database in system database? Do we need to install it?

Roy,

You beat me on this. Even I wrote a paper of TDE and was waiting to have an answer for the Disabling TDE issue before I publish. Your article is...

Carolyn Richardson (3/23/2009)

---

To add also that it will depend on the company you are outsourcing to. Never seen any examples of outsourcing that achieve the expected result, seen plenty of...

Steve Jones - Editor (3/19/2009)

---

A CEO must lead the management of the company, and work to drive forward the vision of the entity, and provide an example of what is...

Steve, in your own word please. One sentence.

Do you think that is a easy job? You have to be amoral for that.

Though I was wrong in my answer but now I can understand or I think I understand why it will return NULL.

You can alter the procedure and drop the procedure...

Those who answer the question correctly without running the query and he is not a newbie in SQL Server then you really did good. All those who cheated by running...

I think this is the best so far.

IF USER DENY TO BACKUP

KILL USER IDENTITY FOR GROUP AND ADMIN

DENY ANY ROLE AND EXIT

If we analyze the error from backup command. It is complaining about log file. So I thought how about trying to attach just MDF file but it failed.

sp_attach_single_file_db @dbname =...

Grant Fritchey (3/13/2009)

---

I posted it to Connect:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=423249

You can vote on it, set the priority, add your comments, especially since this is your issue.

I'm going to keep hacking at it as...

Yep, I check that too. It was only post...