Viewing 15 posts - 6,151 through 6,165 (of 9,244 total)
ajsnyman (1/5/2012)
ALTERDATABASEALTERSCHEMA
These are not object level but higher permissions and imply certain other permissions. Does the user own a schema?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 5:52 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 4:05 am
ajsnyman (1/5/2012)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 2:57 am
Are you running this ad hoc or are you going to schedule it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 1:36 am
Jeffrey Williams 3188 (1/4/2012)
Perry Whittle (1/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 3:15 pm
jspatz (1/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 2:50 pm
if you're executing this within a sql server agent job i'd use a VB script
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:36 am
I use a simple VB script which works quite well at trimming backup files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:32 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:25 am
Ray K (1/4/2012)
Steve Jones - SSC Editor (1/4/2012)
When you rebuilt, and resinstalled, I assume, did you "add Current User" as an administrator? That's easy to miss.
Yeah, that I did remember...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:09 am
sorry missed that bit, they're definitely native backups then?
How are you executing xp_delete_file?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:57 am
tyang (12/23/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:49 am
Tara-1044200 (1/4/2012)
Can someone help me with the sql to schdule restart of sql service and aagent service and also send mesage 15 min before to the users logged in?
You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:42 am
I've had issues in previous times backing up SharePoint databases. Qualifying the database names with QUOTENAME() has always resolved the issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:40 am
ananda.murugesan (1/4/2012)
Right now server is ready with operating system - windows 2008 32 bit, Disk configuration etc..
currently server is work-group, N/W has been configured and server is not member of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:02 am
Viewing 15 posts - 6,151 through 6,165 (of 9,244 total)