Disk and file layouts are bound to be different between dev and live aren't...

David Moutray (1/5/2012)

---

Well, everyone swears that no updates are done. I do not believe any updates are done. I also do not believe that any other processes occur...

CONTROL is the highest available within the database. CONTROL implies all other permissions.

Granting CONTROL at...

also, what does this return

select dp.state_desc, dp.permission_name, dp.class_desc, sch.name

from sys.database_permissions dp

inner join sys.schemas sch on dp.grantor_principal_id = sch.principal_id

where dp.class = 3

remove the denials and the re run the script below and post the exact results

select dp.name, dbp.state_desc, dbp.permission_name, dbp.class_desc

from...

please check the results of the following query

selectsch.name AS SchemaName

, dp.name AS DBUserName

from sys.schemas sch inner join sys.database_principals dp on

sch.principal_id = dp.principal_id

where dp.name = 'yourdbuser'

These are not object level but higher permissions and imply certain other permissions. Does the user own a schema?

Please return the results of the following queries

check explicit permissions

select dp.name, dbp.state_desc, dbp.permission_name, dbp.class_desc

from sys.database_principals dp inner join sys.database_permissions dbp

on dp.principal_id = dbp.grantee_principal_id

where dp.name = 'yoursqlacct'

Check roles assigned

select...

ajsnyman (1/5/2012)

---

I did, the user had nothing else, even if I run:

SELECT * FROM fn_my_permissions (NULL, 'DATABASE');

I only get

entity_namesubentity_namepermission_name

databaseCONNECT

databaseSELECT

I had to explicitly deny alter and update on database permissions for...

Are you running this ad hoc or are you going to schedule it?

Jeffrey Williams 3188 (1/4/2012)

---

Perry Whittle (1/4/2012)

---

If all you're doing is joining the server to a domain then it won't make any difference whether you install SQL Server before or after....

jspatz (1/4/2012)

---

I went into this thinking this should be an easy report using DMV's being that most of the info I need is already present on the canned disk space...

if you're executing this within a sql server agent job i'd use a VB script

I use a simple VB script which works quite well at trimming backup files

doesnt seem to much wrong with the syntax, remember that as an undocumented extended proc this is liable to change with any release.

I'm using SQL Server 2008 R2 SP1...