Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 7
Newest
 Critic
Impact
~10k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
May
2
awarded  Critic
Apr
26
comment Is there ANY risk in granting a superuser CREATE and ALTER procedure permissions in a specific schema?
@ArthurD Thanks, that does provide some additional insight. To me this scenario seems possible, and safe, but I have no way of knowing if there's something obscure I'm missing.
Apr
26
asked Is there ANY risk in granting a superuser CREATE and ALTER procedure permissions in a specific schema?
Mar
14
awarded  Notable Question
Oct
6
awarded  Popular Question
Sep
29
comment Finding dependencies on a SPECIFIC COLUMN (modern way, without using sysdepends)
ALSO: Any idea if this would resolve nested dependencies? ie: a PROD depends on a VIEW which depends on TABLE.COLUMN: if we set criteria on TABLE & COLUMN, will both the view and the proc show in the results?
Sep
29
comment Finding dependencies on a SPECIFIC COLUMN (modern way, without using sysdepends)
This looks excellent. Can you comment on whether this AT ALL or POSSIBLY suffers from the same "stale, out of date" issues as sysdepends? See: sqlblog.com/blogs/aaron_bertrand/archive/2008/09/09/…
Sep
26
asked Finding dependencies on a SPECIFIC COLUMN (modern way, without using sysdepends)
Feb
21
awarded  Notable Question
Aug
14
awarded  Popular Question
Feb
12
awarded  Nice Question
Feb
12
awarded  Scholar
Feb
12
awarded  Student
Feb
12
awarded  Supporter
Feb
12
accepted Is there a way to determine if SQL Server queries are running in memory or going to disk?
Jan
30
asked Is there a way to determine if SQL Server queries are running in memory or going to disk?