Viewing 15 posts - 5,446 through 5,460 (of 7,168 total)
Agreed on wheel inventing activities 😀
Re: the 32-bit issue...to the OP, can you install apps on your client's server as part of your deployment?
Thoughts on creating a 32-bit Windows Service...
July 19, 2011 at 10:47 am
It mentions asym keys right in the error message:
CREATE ASSEMBLY for assembly 'ClrSql' failed because assembly 'ClrSql' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either...
July 19, 2011 at 10:34 am
Not to revive an old thread, but I ran across this when Googling for something else and if I found it someone else will too. In the spirit of educational...
July 19, 2011 at 9:56 am
call.copse (7/19/2011)
Dev teams seem to be a mass of smouldering resentments and insecurities, unless I am just very sensitive.
Well, if you are, then I am too...I could not have said...
July 19, 2011 at 4:39 am
krishnachowdary8 (7/19/2011)
e_id ename
1 abc xyz def
2 ghi jqk
o/p:
e_id ...
July 19, 2011 at 4:24 am
Saravanan_tvr (7/18/2011)
July 19, 2011 at 4:11 am
If you have other things running on your server besides just the Database Engine 5GB may be appropriate but only giving 5GB out of 8GB to SQL sounded low to...
July 19, 2011 at 3:37 am
Per the documentation it requires a constant string, a variable, or any combination concatenating those two options. It does not say that it supports expressions, i.e. returns from functions, built-in...
July 19, 2011 at 3:29 am
It took a bit of searching to find them so I figured I would share the links:
http://www.sqlmag.com/article/tsql3/calculating-concurrent-sessions-part-1
http://www.sqlmag.com/article/tsql3/calculating-concurrent-sessions-part-2
Note: The links in the articles to the "Listings" and "Web Listings" are broken...
July 19, 2011 at 3:13 am
Elliott Whitlow (7/18/2011)
July 18, 2011 at 4:14 pm
UNSAFE was definitely required in this instance. LoadLibrary must have been the culprit.
I will check on TRUSTWORTHY down the line. I am not sure if it was...I think I was...
July 18, 2011 at 4:02 pm
Elliott Whitlow (7/18/2011)
And opc.three, I'd be really careful about turning trustworthy on, I have done that before but I much prefer to go the other route now.
I know...but I think...
July 18, 2011 at 3:48 pm
I think you are spot-on with your idea of employing the SQLCLR for this. You might want to try posting the question to the MSDN SQLCLR forum. You may get...
July 18, 2011 at 3:16 pm
Sorry. I don't have all your tables here so did not bother compiling it. I did not intend for you to compile it anyay...it was just to strip away the...
July 18, 2011 at 2:44 pm
Sarath Vellampalli (7/18/2011)
Hi opc,I am using this code in SP and we need to append the data to same text file with loop.
so please help me on this.
I understand, but...
July 18, 2011 at 2:30 pm
Viewing 15 posts - 5,446 through 5,460 (of 7,168 total)