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

  • 0 posts edited
  • 0 helpful flags
  • 5 votes cast
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
Aug
22
awarded  Curious
Aug
21
comment Database Mail connection to exchange - Resets and timeouts
I have been working with the Admin, but we aren't seeing anything that suggests this is on the Exchange side. Exchange is responding to all the network traffic with no latency, but Database Mail is taking up to 30 seconds to resume sending the traffic. 14 DATA packets equal 20KB, and it only gets through about 11 of these sets before it hits the timeout.
Aug
21
asked Database Mail connection to exchange - Resets and timeouts
Mar
31
comment Comparing CLR Functions in Visual Studio SSDT
I'm able to get the compare working by moving all the code to one project. This isn't what I was hoping to do, but I think it will be our best option until this is fixed.
Mar
27
comment Comparing CLR Functions in Visual Studio SSDT
I looked in the Model.xml file and these properties are not defined there. They are in the C# code: [SqlFunction(IsDeterministic = true, DataAccess = DataAccessKind.None)]
Mar
26
asked Comparing CLR Functions in Visual Studio SSDT