I am going to create my own thread for this. I am having problems with my stored procedures for removing users from role and adding users to role. My roles work but these two procedures do not. I get an error when trying to deploy my dbase saying that the stored procedures either do not exist or I do not have the right permissions.. what is going on? everything weorked fine until I uploaded to server and changed my conn string to point to the online dbase. I have tried re-deploying and nothing. I need to get this fixed asap.. any help would be greatly appreciated.
