Viewing 15 posts - 6,136 through 6,150 (of 9,244 total)
DIB IN (12/30/2011)
Data has been Encrypted using Key. Now we restore the database back-up to a new server.
Are you usIng transparent data encryption?
DIB IN (12/30/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2012 at 5:06 pm
GilaMonster (1/7/2012)
I count no more than an intern straight out of school that braindumped his way through a single SQL certification.
Sadly this is so true, it renders the certification and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2012 at 4:43 pm
Small indexes (I.e. few pages) are scattered because the pages fill in gaps in used extents. It's likely the database engine would incur extra I\O to move pages to make...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 11:24 am
granting permissions on the xp worked for me, i suspect the account trying to grant has insufficient permissions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 11:18 am
sporoy (1/6/2012)
yes, the error is :Msg 22001, Level 16, State 1, Line 0
xp_instance_regread() returned error 5, 'Access is denied.'
This works for me
grant execute on object::sys.xp_instance_regread to public
Who are you logged...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 10:32 am
Bernardinho (1/5/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 6:17 am
farzad.jalali (1/6/2012)
here is where I run the command:C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
run setup from the original install CD\DVD and try launching the command from there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 4:08 am
Please create a new post to get help with any issues.
In regard to this issue what does the following file show
farzad.jalali (1/6/2012)
Please review the summary.txt logs for further details.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 3:36 am
GilaMonster (1/5/2012)
Perry Whittle (1/5/2012)
Granting CONTROL at the schema level is quite brave IMHO 🙂I could use a few other words than 'brave' I think 🙂
😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 5:54 pm
David Moutray (1/5/2012)
Hmmm. It is quite low when I run this process in the dev environment.
Disk and file layouts are bound to be different between dev and live aren't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 1:09 pm
David Moutray (1/5/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 12:21 pm
ajsnyman (1/5/2012)
To be honest, it seems I do not understand the function of the CONTROL permission.
CONTROL is the highest available within the database. CONTROL implies all other permissions.
Granting CONTROL at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 11:28 am
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 10:39 am
ajsnyman (1/5/2012)
Tried it, then right back to updates and altering ;(
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 10:26 am
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'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 6:21 am
Viewing 15 posts - 6,136 through 6,150 (of 9,244 total)