Viewing 15 posts - 3,016 through 3,030 (of 9,725 total)
ramana3327 (12/13/2014)
We are assigned public server role to that...
December 15, 2014 at 6:02 am
ramana3327 (12/11/2014)
SA account is already disabled. so I need to give public server role and map as dbowner for remaining databases right?
Yes. That will prevent them from accessing server level...
December 12, 2014 at 5:20 am
ScottPletcher (12/11/2014)
Have you compressed large indexes when useful?
Have you reviewed that you have the best clustered index on each table? After that,...
December 12, 2014 at 5:19 am
Brandie Tarvin (12/11/2014)
ramana3327 (12/10/2014)
Hi,We have a login with windows authentication. That login has sysadmin and public server roles. But We didn't map that login to some user databases.
There is your...
December 11, 2014 at 1:02 pm
If you are sure that your growth rate holds steady at 70 GB per month, then take that number multiplied by the number of months you're projecting. Add that to...
December 11, 2014 at 11:37 am
So again, what are you trying to accomplish?
Without that context, your original question is rather meaningless to the rest of us.
December 11, 2014 at 10:40 am
As much as it pains me to say this (because it could cause performance issues), I think your best bet is to put in an AFTER trigger to rollback the...
December 11, 2014 at 7:19 am
I've never actually disabled any login except the sa and guest (old days) logins. And so far as I know, that's a server-level setting only. I'm pretty sure that once...
December 11, 2014 at 7:17 am
I think you are correct. I would advise creating a server level public login to go with that DB login, though, for ease of maintenance and to prevent it from...
December 11, 2014 at 7:02 am
GilaMonster (12/11/2014)
There's no need to have free space on the drive, as long as there's free space in the database...
December 11, 2014 at 7:00 am
I apparently am not understanding what your needs are. Do you need to size the database for auto-growth? Are you trying to add more space to the drive where your...
December 11, 2014 at 6:59 am
pdanes (12/11/2014)
Brandie Tarvin (12/11/2014)
What is the business need to use a schema object to prevent this?
I didn't specify schema, and in fact, have no idea how a schema could be...
December 11, 2014 at 6:56 am
ramana3327 (12/10/2014)
Hi,We have a login with windows authentication. That login has sysadmin and public server roles. But We didn't map that login to some user databases.
There is your answer right...
December 11, 2014 at 6:45 am
Was it perhaps granted only on the database level security then?
I.E., try opening up the Database, going to Security, and adding a new user via the GUI.
If that doesn't work,...
December 11, 2014 at 6:43 am
What is the business need to use a schema object to prevent this?
December 11, 2014 at 6:41 am
Viewing 15 posts - 3,016 through 3,030 (of 9,725 total)