Viewing 15 posts - 91 through 105 (of 285 total)
This is crude, but seemingly effective...
Save the following code as convert_sql_xml_to_html.ps1. Be aware that the pasted code contains tab characters to tidy up the HTML.
# See "SQL Server 2008 R2...
January 12, 2012 at 6:27 am
Still looking for some ideas... 🙂
January 11, 2012 at 5:23 am
scott.shaw (1/4/2012)
January 4, 2012 at 2:22 pm
jasona.work (12/7/2011)
About the only suggestion I could make, would be to either hide the script window...
Good idea. I didn't think about that. That could solve another issue for me. Thanks...
December 7, 2011 at 7:45 am
anthony.green (12/7/2011)
the task isnt set to stop after X amount of time is it, usually the default is 72 hours
That checkbox is not selected, but it turns out that the...
December 7, 2011 at 7:42 am
By shear dumb luck today, I happened to kill the window (by clicking on the "X" in the top right hand corner of the window) that was running the index...
December 7, 2011 at 7:27 am
Elliott Whitlow (10/18/2011)
So the short answer is that if you use NO mount points then xp_fixeddrives can work for you, however, I like solutions that work in ALL cases.
Good to...
October 18, 2011 at 11:26 am
Elliott Whitlow (10/18/2011)
Don't depend on xp_fixeddrives it won't give you a true picture.
Hmmm... Really? What causes xp_fixeddrives to yield a faulty picture?
We use xp_fixeddrives to monitor all of our drives...
October 18, 2011 at 11:01 am
Elliott,
Thanks for the quick response. It sounds as if we already configure our SQL Server installations in a fashion similiar to yours.
In your post, if I am understanding correctly, all...
October 18, 2011 at 10:21 am
Quick follow up...
I tested the code with an image, and it seemed to work the same as with a text file. Thanks again, Jeff.
October 14, 2011 at 1:12 pm
Jeff Moden (10/13/2011)
...in order to keep from generating the "stray" charcters which are typically used to identify the file type internally to the file.
Hmmm... I was taking all of the...
October 13, 2011 at 7:41 pm
I tried "-C RAW" as follows, but I still got the "stray" characters.
bcp "select Document from dba.dbo.Test_TextTable" queryout "C:\cron\temp_out.txt" -S HRAC4\DSTANDALONE1 -T -C RAW
October 13, 2011 at 7:34 pm
This appears to come reasonably close to the output that I am looking for, but it uses bcp.exe instead of sqlcmd.exe:
bcp "select Document from dba.dbo.Test_TextTable" queryout "C:\cron\temp_out.txt" -S HRAC4\DSTANDALONE1 -T
Enter...
October 13, 2011 at 7:21 pm
Perry,
I didn't get a chance to spend much time on the cluster build tonight (too much grass to cut... 🙁 ). But, I did get a chance to download and...
August 29, 2011 at 7:05 pm
Thanks, that helps a lot. I plan to check this out after I get home from work.
August 29, 2011 at 3:13 am
Viewing 15 posts - 91 through 105 (of 285 total)