Reputation
324
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 10
Newest
 Yearling
Impact
~13k people reached

  • 0 posts edited
  • 0 helpful flags
  • 5 votes cast
Nov
12
awarded  Yearling
Oct
24
awarded  Notable Question
Feb
17
comment Permission to view execution report in SSIS Catalog
A relevant Microsoft Connect item has been added since you asked this question. ( I just up-voted it because we want to do the same thing where I work ). "Execution History Reports Permission in SSISDB Catalog - by Parikshit Savjani" connect.microsoft.com/SQLServer/feedback/details/1051458/…
Oct
13
awarded  Popular Question
Sep
24
awarded  Autobiographer
Jun
30
awarded  Self-Learner
Apr
29
answered '+' operator with one operand!
Dec
8
revised Using SQL Server SMO with a Port number
Added note regarding enabling TCP/IP connections to SQL Server
Dec
7
answered Using SQL Server SMO with a Port number
Dec
6
awarded  Quorum
Nov
26
comment PowerShell to get database schemas
What's the scope of this question? Do you need help with XML in any way, or is that just background? When you say "I want to get all "schemas"", do you just need a list of the schema names from a database? Or, do you want to access objects within each schema in the database? If so, what do you want to do with the database schema objects?
Nov
22
revised Need for indexes on foreign keys
Added another helpful link
Nov
22
answered Need for indexes on foreign keys
Nov
21
revised SQL Server, how to execute a job against all databases on server?
added 285 characters in body
Nov
21
revised SQL Server, how to execute a job against all databases on server?
added 227 characters in body; discovered that "SELECT at_at_SERVERNAME" is enough to break the edit commit
Nov
21
answered SQL Server, how to execute a job against all databases on server?
Nov
13
awarded  Popular Question
Nov
12
awarded  Supporter
Oct
24
answered Does failed task considered to be run to completion in SQL Server maintenance plan terminology?
Oct
22
accepted SQL Server 2012 SQL Agent Job with PowerShell step fails on Out-File cmdlet with “ReportWrongProviderType” error