We have a SQL 7 set of databases, and we need to grant dbowner permissions on specific databases to groups of people. I have set up groups on NT, and in SQL, but the dbowner property fails when we run reports requiring sql to drop a table. The dbowner property works, and the report runs fine, for users who are defined separately in sql (with the same dbowner properties as the groups). PLEASE tell me that there is something I am missing...and that I don't have to enter each of my users as a separate SQL login. Any suggestions/solution ideas are appreciated!