Viewing 15 posts - 346 through 360 (of 645 total)
The MSDN documentation for xp_cmdshell doesn't seem to show that this is possible, but xp_cmdshell does seem to be able to return whatever return code you want, as long as...
September 13, 2015 at 11:32 pm
It should be noted that this question has been cross-posted on Stack Overflow:
How to unload native dll (called in clr udf own function) from SQL Server process?
John, I posted another...
August 30, 2015 at 3:04 pm
David.Poole (8/29/2015)
August 29, 2015 at 2:58 pm
David.Poole (8/27/2015)
I don't believe Array.Clear() is doing what you expect it to do. The MS documentation says it sets a range of array elements to a default value. I don't...
August 28, 2015 at 1:30 pm
Hi there. This sounds like an SSIS (Integration Services) question and not a SQLCLR question. If so, there is probably a more appropriate forum that will get this answered much...
June 9, 2015 at 4:24 pm
Jeff Moden (5/28/2015)
Solomon Rutzky (5/28/2015)
But SQLCLR is far better than the alternatives of xp_cmdshell, the OLE Automation Procedures, extended stored procedures, and sometimes even OPENROWSET / OPENQUERY
Solomon should actually know...
May 29, 2015 at 2:51 pm
eric.notheisen (5/29/2015)
May 29, 2015 at 9:43 am
dmbaker (5/29/2015)
Charles Kincaid (5/29/2015)
rasika.nanayakkara (5/29/2015)
I tried this example and found out that Excel and Word documents cannot open and it says they are corrupt.
Since I did not see any mention...
May 29, 2015 at 7:29 am
dmbaker (5/28/2015)
But personally, I do like having the option of setting FileMode and FileAccess.
Sure, nothing wrong with wanting more control. It might be better to change this up entirely though,...
May 29, 2015 at 7:16 am
Orlando Colamatteo (5/28/2015)
Jeff Moden (5/28/2015)
Solomon Rutzky (5/28/2015)
But SQLCLR is far better than the alternatives of xp_cmdshell, the OLE Automation Procedures, extended stored procedures, and sometimes even OPENROWSET / OPENQUERY
Extremely personal...
May 28, 2015 at 11:20 pm
dmbaker (5/28/2015)
May 28, 2015 at 3:34 pm
Hi Eric. As I mentioned in my comment on your previous article (regarding reading the file), I think this is a good topic and concept, but there are some aspects...
May 28, 2015 at 11:07 am
sanjarani (5/26/2015)
At the time it was said...
May 28, 2015 at 12:20 am
Hi Eric. Good topic. I definitely like the concept, but need to mention a few notes regarding SQLCLR best practices:
!! Critical Issue !!: You open a FileStream but you don't...
May 28, 2015 at 12:03 am
Sorry for the delay in responding. It initially seems like the account that SQL Server is logging on as (the service, typically "MSSQLSERVER" if it is the default instance) does...
May 15, 2015 at 2:26 pm
Viewing 15 posts - 346 through 360 (of 645 total)