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

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
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
Aug
5
accepted Changing autogrow settings with database mirroring
Aug
5
answered Changing autogrow settings with database mirroring
Jul
31
comment Changing autogrow settings with database mirroring
I guess that is the route I'll be going down. I'm just glad I discovered this before we actually grew a file by 30,000% :)
Jul
31
awarded  Commentator