Viewing 15 posts - 2,041 through 2,055 (of 6,036 total)
Mark Eckeard (3/26/2013)
Sean - what did you have in mind? What can I do to make it more scalable?
I don't think you can do it totally dynamical, but you...
_____________
Code for TallyGenerator
March 26, 2013 at 6:44 pm
Steven Willis (3/26/2013)
... no rounding approximations.
What a misconception.
Try add this to the final SELECT in your query:
, SQL_VARIANT_PROPERTY(CurrDiscount, 'basetype'), SQL_VARIANT_PROPERTY(CurrDiscount, 'scale'), SQL_VARIANT_PROPERTY(CurrDiscount, 'precision')
...
_____________
Code for TallyGenerator
March 26, 2013 at 5:24 pm
Erin Ramsay (3/26/2013)
Oh sorry, Gail, I forgot to mention that there are no where conditions.. this is pulling the entire table back.
Oh...
Oh-oh-oh.
They've got you.
No way out. Final destination. 🙂
Everything they...
_____________
Code for TallyGenerator
March 26, 2013 at 5:03 pm
Michael L John (3/26/2013)
Specifically to xp_cmdshell, I say disable it. The analogy is that locking a door keeps honest people honest.
The analogy is - you're locking the door and...
_____________
Code for TallyGenerator
March 26, 2013 at 2:26 pm
OK, for everyone who have read to this point searching for a professional advice, the bottom line is:
Disabling xp_cmdshell is a stupid idea.
It only creates obstackles for developing solutions and...
_____________
Code for TallyGenerator
March 25, 2013 at 11:15 pm
Still no answer on professional questions.
No support for the point you made.
Pretty typical...
_____________
Code for TallyGenerator
March 25, 2013 at 9:09 pm
opc.three (3/25/2013)
What gave you that impression?
Lack of answers on direct questions from me and Jeff.
You have nothing to support your words.
Seriously, where are you going with it Sergiy? We...
_____________
Code for TallyGenerator
March 25, 2013 at 8:38 pm
opc.three (3/25/2013)
Sergiy (3/25/2013)
When one does not want to admit of being wrong he's resotring to personal attacks.😛 You just made my point for me. I think we're done here 🙂
So,...
_____________
Code for TallyGenerator
March 25, 2013 at 8:31 pm
When one does not want to admit of being wrong he's resotring to personal attacks.
I can clearly see the point. And I spent most of my working time in environments...
_____________
Code for TallyGenerator
March 25, 2013 at 8:17 pm
opc.three (3/25/2013)
Care to clarify what you meant? Since it is clear now that you did not say "script" to mean something submitted for normal review and deployment.
Not sure what needs...
_____________
Code for TallyGenerator
March 25, 2013 at 7:07 pm
opc.three (3/24/2013)
Sergiy (3/24/2013)
Version control. Change management processes. Code review. Layers...
What all these words have to do with stealing data by launching an ad-hoc query using SA privilages?
Or you really believe...
_____________
Code for TallyGenerator
March 24, 2013 at 10:32 pm
opc.three (3/24/2013)
But consider the employee in the sysadmin Role looking to steal data without being detected.
And?
How adding an "sp_configure" command to a script used for stealing data will...
_____________
Code for TallyGenerator
March 24, 2013 at 9:17 pm
opc.three (3/24/2013)
All of those things should be done in addition to leaving xp_cmdshell disabled.
If those things are done there is no point of disabling xp_cmdshell.
_____________
Code for TallyGenerator
March 24, 2013 at 8:42 pm
opc.three (3/24/2013)
You're still hung up on external scenarios.
Not really.
Replace "intruder" with "employee gone nuts".
What does it change?
_____________
Code for TallyGenerator
March 24, 2013 at 8:36 pm
opc.three (3/24/2013)
_____________
Code for TallyGenerator
March 24, 2013 at 7:33 pm
Viewing 15 posts - 2,041 through 2,055 (of 6,036 total)