1,248 reputation
534
bio website
location
age
visits member for 1 year, 11 months
seen 15 hours ago
stats profile views 54

Jul
10
awarded  Popular Question
Jun
29
awarded  Popular Question
Jun
8
awarded  Caucus
Jun
6
comment Release SQL Server Memory usage
Please see this question: dba.stackexchange.com/questions/6691/…
Jun
5
awarded  Yearling
May
24
accepted Why index REBUILD does not reduce index fragmentatation?
May
24
asked Why index REBUILD does not reduce index fragmentatation?
May
1
awarded  Necromancer
Mar
31
accepted How to deny drop permission for a table?
Mar
31
comment How to deny drop permission for a table?
I'm accepting this answer because it answer my question partly.
Mar
31
comment How to deny drop permission for a table?
Ok, this prevents drop table for the whole database, not just for one table.
Mar
31
comment How to deny drop permission for a table?
I'm talking about db_owner role, not dbo user, those are different things.
Mar
30
comment How to deny drop permission for a table?
If this user has a db_owner role, is does not seem to affect the users ability to drop this table.
Mar
30
asked How to deny drop permission for a table?
Mar
26
accepted What factors prevent and delay TRUNCATE command?
Mar
25
asked What factors prevent and delay TRUNCATE command?
Mar
1
accepted Is configuring Database mail considered as a security threat?
Feb
29
comment Is configuring Database mail considered as a security threat?
There stands in this document that: Because some system procedures interact with the operating system or execute code outside of the normal SQL Server permissions, they can constitute a security risk. System stored procedures such as xp_cmdshell or sp_send_dbmail are off by default and should remain disabled unless there is a reason to use them.
Feb
29
asked Is configuring Database mail considered as a security threat?
Feb
23
awarded  Nice Question