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...
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')
...
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...
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...
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...
March 25, 2013 at 11:15 pm
Still no answer on professional questions.
No support for the point you made.
Pretty typical...
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...
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,...
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...
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...
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...
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...
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.
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?
March 24, 2013 at 8:36 pm
opc.three (3/24/2013)
March 24, 2013 at 7:33 pm
Viewing 15 posts - 2,041 through 2,055 (of 6,036 total)