I just tried that query and it should be returning other sql logins in the rolename column with which rights they have been explictly given to tables. I am using a sql 2000 box.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…