removing user

Hello,
I have a problem with removing an user on a SQLSERVER V7 base.
I can suppress the user, but it still exist for the role PUBLIC.
Can you help me ?Do you mean that you remove the user from the database, but they can still get in through Public, or are you getting an error when you try to delete the user?

blindman|||Hi...
What u mean by suppress the user...? What errror message u r getting?
U can remove user from User Roles still it will exists in Public. Do the user owns some objects ? guests are allowed in the DB ?

Cheers :)

Shaji

Originally posted by jleb
Hello,
I have a problem with removing an user on a SQLSERVER V7 base.

I can suppress the user, but it still exist for the role PUBLIC.

Can you help me ?|||I remove the user from the database, but it still exists whem I look the Public role.

Thank you fopr your help, I have found a solution with the command sp_revokedbaccess.

Originally posted by blindman
Do you mean that you remove the user from the database, but they can still get in through Public, or are you getting an error when you try to delete the user?

blindman

Removing Data Base Size Restriction

About a month ago I restored a data base that had been originally created in MSDE into a full version of SQL Server 2000. I thought that the size restriction would automatically be removed by putting it into the full version of SQL. I was wrong and about a week or so later the data base reached the 2GB size and needed attention. I received some assistance through Microsoft and they walked my client through the process of removing the size restriction. Since then everything has been OK.

Now I am doing something similar. My client has a data base that was originally created in MSDE. We upgraded them to SQL Express and the data base has now grown to 4GB which is the max that SQL Express allows.

We will be installing SQL for Workgroups this week.

My question is this. Is there a setting I must change inside the data base or in SQL for Workgroups that will allow the data base to grow beyond 4GB? We need to let it expand to whatever they need and I cant seem to find any documentation on whether or not I have to change a setting for this data base.

Thanks for your help. Jean

It's possible that you may need to change the autogrowth settings for the database. In Management Studio, right click the database, choose Properties, then go to the Files page. Check what's in the Autogrowth column for each file and verify that it's either set to "unrestricted growth", or restricted to a sufficiently large size. Looking at an Express Edition installation, it doesn't appear that a 4 GB autogrowth limit is selected by default, however. You should be able to load Developer Edition onto a test machine and play around with this a bit before you go live.|||Thank you David. I will take a look at that when we upgrade the customer. I am certain that is where I will find the settings. I appreciate your help. Jean