That's why this one kind of annoyed me.  Why go to all the trouble of creating a new role when an individual deny is so much simpler?  It wasn't an...

If I understood correctly he needs access to all of the table they have access to except the Vacation table.  So add him to the role and then DENY him...

I had a SP that was taking longer and I found out the optional parameter was doing it.  If I supplied the value it went in 30 seconds.  If I...

I got around it sortof.  I used the DTS export wizard to create it.  (It works when I hit run, I just can't MODIFY it)  So I just made sure that...

I'm using SQL server 2000 and having the same problem.  I have a view that uses 3 tables.  I am manually creating DTS scripts and I want to export the...