Viewing 15 posts - 5,071 through 5,085 (of 7,168 total)
Jeff Moden (10/14/2011)
@opc.three,What's funny about all of this is that xp_DirTree, xp_CmdShell, xp_FileExists, etc, etc, etc all live in a single DLL called XPSTAR.DLL.
XPSTAR.dll, not sure why that is amusing...
October 14, 2011 at 10:13 am
rmechaber (10/14/2011)
opc.three (10/13/2011)
October 14, 2011 at 9:24 am
Jeff Moden (10/13/2011)
Needless to say, I prefer the "all in one place" aspect.
There is merit in your argument for sure. I would press you for details initially, but as previously...
October 13, 2011 at 10:35 pm
Elliott Whitlow (10/13/2011)
opc.three (10/13/2011)
Elliott Whitlow (10/13/2011)
Given a particular system it may make as much if not more sense to handle the file...
October 13, 2011 at 10:23 pm
Elliott Whitlow (10/13/2011)
opc.three (10/13/2011)
October 13, 2011 at 5:18 pm
Jeff Moden (10/13/2011)
...because of those dangerous recommendations, xp_CmdShell continues to receive a black-eye that it really doesn't deserve. ...
I'll walk elbow-to-elbow with you on this idea any day. The results...
October 13, 2011 at 5:06 pm
Personally I think using the CLR functionality to access files from with a T-SQL context, while preferable over using xp_CmdShell, is still a misguided application of the CLR. It is...
October 13, 2011 at 11:06 am
Jeff Moden (10/12/2011)
opc.three (10/11/2011)
An example might be calling a web service to cleanse, verify and standardize personal information like name, address and phone number before moving the cleansed data through...
October 12, 2011 at 11:20 am
What are you trying to do? What are you worried about the public role having permissions to do that you want to take away?
October 11, 2011 at 1:31 pm
Jeff Moden (10/10/2011)
Nope... my comment wasn't directed specifically at you, Orlando. If it was, I'd have said, "Orlando, stop....". 😉
Good to know...if you did say that I would stop,...
October 11, 2011 at 11:16 am
Jeff Moden (10/9/2011)
opc.three (10/7/2011)
Please, have a look at PowerShell. Once you ramp up you will never want to open CmdShell again.
Well I might especially if it's to fire off PowerShell...
October 10, 2011 at 10:15 am
JeremyE (10/7/2011)
October 7, 2011 at 3:53 pm
jasona.work (10/7/2011)
October 7, 2011 at 12:30 pm
I am happy you succeeded in steering them towards SQL Server. I am curious how they planned on solving this particular problem using Access.
I get why you would landed on...
October 7, 2011 at 12:27 pm
Agreed on using Database Roles. Triggers are a place to look to cover all bases but with a message like "delete is denied on the object" this points to an...
October 6, 2011 at 10:39 am
Viewing 15 posts - 5,071 through 5,085 (of 7,168 total)