Viewing 15 posts - 26,641 through 26,655 (of 59,102 total)
Ok, Orlando... I'd really be interested in how that bit of fine code could be modified to reject usage of cmd.exe by a given user because I just saw a...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 7:50 pm
Might have finally found a method to prevent execution of Cmd.exe.
http://technet.microsoft.com/en-us/library/cc975912.aspx
I'll have to give this a try.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 4:36 pm
opc.three (6/12/2013)
I already did.
http://www.sqlservercentral.com/Forums/FindPost1450182.aspx
I showed how to recognize that a call to the cmd shell was being made within Windows using WMI. Granted, that exercise only detected the occurrence...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 4:19 pm
opc.three (6/12/2013)
In my estimation, and from seeing what developers typically produce and have left behind when left to their own devices when using it, xp_cmdshell guides developers into, practically promotes,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 2:43 pm
opc.three (6/12/2013)
sneumersky (6/12/2013)
Can SQL_Enthusiast's issue be solved with a WMI task or data reader? I have not used it in ages, nor am I a WQL expert 🙁
A WMI...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 11:55 am
opc.three (6/12/2013)
As for MS supposedly "coming to their senses with xp_CmdShell" goes, just because you disagree with something, doesn't make it bad. It just makes it bad for you.
It's...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 11:45 am
That's the reason for my question about how does the OP know if they've had a deadlock. I don't believe they'd be asking if they knew about either TF...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 11:41 am
opc.three (6/11/2013)
Jeff Moden (6/11/2013)
opc.three (6/11/2013)
Thank you for bringing the conversation back to the original intent. Maybe you doing it will make it stick.
Great idea but YOU are not the one...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 7:55 am
opc.three (6/11/2013)
Jeff Moden (6/11/2013)
For example, sp_MakeWebTask was very well documented and supported and it went away virtually overnight because Microsoft thought everyone would go ga-ga over SSRS :sick:
sp_MakeWebTask was likely...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 7:51 am
lshanahan (6/11/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2013 at 9:12 pm
opc.three (6/11/2013)
Thank you for bringing the conversation back to the original intent. Maybe you doing it will make it stick.
Great idea but YOU are not the one to determine what...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2013 at 8:58 pm
TheSQLGuru (6/10/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2013 at 5:05 pm
AlanLSmith (6/11/2013)
But if it's not available, here's a query that will give you the dates for a given year and month.
Still working on how...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2013 at 4:39 pm
AAKR (6/11/2013)
Hi All,2days ago we have a dead lock.
how to find out, for what cause the dead lock got occured?
How do you know you had a deadlock 2 days ago?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2013 at 4:32 pm
Manie Verster (6/11/2013)
Jeff Moden (6/10/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2013 at 3:55 pm
Viewing 15 posts - 26,641 through 26,655 (of 59,102 total)