Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
10
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 5 votes cast
Nov
16
awarded  Popular Question
Sep
22
comment Disabling variable substitution inside SQLCMD script when using :r syntax
@mskinner - That is what I will do to get around the issue, I was hoping I could stick with sqlcmd, but it looks like it will be easier to use powershell.
Sep
16
comment Disabling variable substitution inside SQLCMD script when using :r syntax
I want to run Script1.sql, Script2.sql, etc... without variable substitution.
Sep
16
asked Disabling variable substitution inside SQLCMD script when using :r syntax
Sep
11
accepted Why does dm_os_memory_clerks have MEMORYCLERK_SQLCLR values on one NUMA node?
Sep
3
asked Why does dm_os_memory_clerks have MEMORYCLERK_SQLCLR values on one NUMA node?
Aug
6
comment How to capture PRINT statements from TSQL called by CLR stored procedure
@srutzky thanks for the update. I found that we are using UNSAFE because there are static variables in the code. I was able to remove them and now we are running in EXTERNAL_ACCESS. Thanks again for the help!
Jul
30
accepted How to capture PRINT statements from TSQL called by CLR stored procedure
Jul
30
comment How to capture PRINT statements from TSQL called by CLR stored procedure
Thanks srutzky! I was able to use to your first example to get my code working (the assembly is already UNSAFE because we are doing filesystem operations, so that is not a concern), but I'd like to understand the value of using the delegate. Can you clarify what you mean about the static class variable? My 'CaptureMessage' code is just SqlContext.Pipe.Send(args.Message).
Jul
29
asked How to capture PRINT statements from TSQL called by CLR stored procedure
Jul
13
comment Using variable for database name
Kim and Aaron Bertrand make a good and correct point below that sp_MSforeachDB is not supported and has some issues. It doesn't always operate over the entire list of databases.
Jul
13
revised Using variable for database name
formatting
Jul
13
answered Using variable for database name
Jul
10
awarded  Autobiographer
Jul
10
accepted Can CLR execution continue after 'THROW' is encountered in T-SQL?
Jul
9
asked Can CLR execution continue after 'THROW' is encountered in T-SQL?
Jul
9
awarded  Informed
Jul
9
accepted CLR/C# equivalent to XACT_STATE()
Jul
8
asked CLR/C# equivalent to XACT_STATE()
Oct
15
revised Changing autogrow settings with database mirroring
added 67 characters in body