Brandi I'd hope it would be easy to get a free application on the approved list easily;

I've got to recommend 7zip's command line version, i use it a lot.

here's a...

Jim you could use something like this example, whether you need a string or a full command;

it's just converting to varbinary and pasting the string into the final script;

--obfuscate a...

no. not possible.

if it's not raw text, it...

not enough information kurt; remember we are not in your cube, looking over your shoulder, knowing what you know.

a purchase order is a form with a specific layout. it's...

kurt your going to have to provide a lot more information, i think you need to "think outside of the box" on this one.

you can create a pdf from raw...

man i learn more hear every day; thanks once again to you Gianluca;

yes, your trigger could look for a WHERE statement...you could also limit the trigger to test for specific...

I like that idea, Gianluca;

the only problem with dbcc inputbuffer is it is limited to 256 characters....I'd think offhand that a delete is going to be inside that limit to...

well, this will get you the hours where at least one answer exists i think;

if you need to know that zero answers were answered at 3am, that's why you'd need...

i think we'd need a CREATE TABLE definition and a few rows of sample data;

for the most part, i think it's joining a Calendar table to get all possible hours...

he means the operating system...command prompt's COPY command does it in a single line: you could call the Shell command for it:

in SQL

EXEC Master.dbo.xp_CmdShell 'COPY C:\Temp\Header.txt+C:\Temp\Test01.txt C:\Temp\MyWork.txt'

in a command window,...

you'll need to take that into consideration when you upgrade; If you have a separate development server, I'd start testing with higher compatibility right away just to start tracking if...

beautiful; exactly what i was looking for; thanks so much, Gianluca!

do you think looking at sys.sysaltfiles fo rthe master database, and assuming there is a parallel \Backup folder at the same level as the \DATA folder is safe?

--C:\Program Files\Microsoft...

darn; both that registry key and the that script on SQL tips assumes you know WHICH installation you are looking for already...MSSQLSERVER,MSSQL.1,MSSQL.2, etc;

I wanted it to be a bit more...

your idea is even easier to implement; you simply update the source with some tags and poof, some simple CSS on the page and they can see or not see...