Viewing 15 posts - 26,596 through 26,610 (of 59,102 total)
Dave Vroman (6/20/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2013 at 10:11 am
Mike Dougherty-384281 (6/20/2013)
Are we solving the right problem?
Jeff asked why use xp_cmdshell to get to a third-party tool & suggested db_sendmail: depending on...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2013 at 10:04 am
SQL-DBA (6/20/2013)
Jeff Moden (6/19/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2013 at 9:24 am
I don't believe you'll find anyone more pro-xp_CmdShell or pro_BCP than myself but I can't figure out why you bothered with either for this task since sp_SendDBMail could have easily...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2013 at 11:54 pm
Gary Varga (6/19/2013)
I guess it once more shows that all of us have something to offer 🙂
Spot on, Gary.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2013 at 7:21 am
This is absolutely incredible.
Gary, thanks for kicking off the thread with the bone of the code and some great examples to get me thinking in loops again. It's been...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 18, 2013 at 9:16 pm
Ah... sorry. Misread a post and had to remove a bad answer.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 18, 2013 at 5:21 pm
Lowell (4/9/2013)
/*--Results
cellindex containerid containerlength istwincarry ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 18, 2013 at 5:19 pm
If you refer back to the timeline (minus your spam filter getting in the way, which was quite funny by the way) we were not technically in the midst of...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 18, 2013 at 12:10 am
SQL_Surfer (6/17/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2013 at 11:13 am
Thank you Gary and calvo... this is a great start for me. It's been a thousand years since I've gone anywhere near procedural code outside of SQL Server. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2013 at 11:10 am
As a continuation of my previous question, what does the "0" in the parenthesis of .GETVALUE(0) do?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2013 at 8:45 am
Gary Varga (6/17/2013)
$wmiObject.GetValue(0)["SystemName"] + "','" + $wmiObject.GetValue(0)["DeviceID"]+ "')"
I am sure that you will have come...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2013 at 8:38 am
calvo (6/17/2013)
I have the very script you're looking for that does exactly what you want.
I pieced it together using a couple functions I found online and it works very...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2013 at 8:35 am
Gary Varga (6/17/2013)
$commandText = "INSERT DiskSpace VALUES ('" + $wmiObject.GetValue(0)["SystemName"] + "')"
$command = $conn.CreateCommand()
$command.CommandText = $commandText
$command.ExecuteNonQuery()
This way is not necessarily...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2013 at 8:26 am
Viewing 15 posts - 26,596 through 26,610 (of 59,102 total)