I always break it into peices;

the Header and Tail are appended to the body;

then i can test of the Body is an empty string, i can convert it to "No...

SQLHeap (8/28/2012)

---

We do most of our right granting through AD groups. Can I explicitly restrict or deny access to just read for a single person from a group that...

for the delimiter issue, use something you KNOW will not exist in the data; a tilde ~ for example.

then everything will come in as asingle column of wide data.

For...

here's an example i've posted lots of times.

this inserts allt eh data into a table named "BULKACT, that has a single column "RAWDATA"

it imports all the files in four different...

it's fairly easy; you would want to use BULK INSERT to bring the text files into a SQL table...but you have to know the layout of the data, and create...

well, CSS wise, the closest assignment to the object overrides the css at the higher level;

do you have a set number of levels, or at least some method to identify...

for assigning...

John here's your example you posted, modified so every other row is manill folder/white;

if i have specific cells i want colored, i usually use a CSS class.

let me know if...

ok, this gets you your value as datetime, right? i guess you could manipulate it a bit more if you really wanted AMPM in it, but i would want the...

if you convert to CHAR(12), most of the string gets truncated no matter the format.

try a CHAR(37) instead.

lol according to this web site,

http://www.onlygold.com/tutorialpages/yourweightingold.asp

a fat boy like me is worth 5.4 million dollars or so;...

ok I see that works;

With my example values, I also saw that SQL DES and TRIPLE_DES are not interchangable with the results from your function;

I think you'll have to...

andersg98 makes me think you could do a proof of concept;

create a new job that does a COPY ONLY with verify backup to the network share;

set it to...

The new Query button will open up with the connection information for whatever Server/Database is currently selected in the Object Explorer.

If Object Explorer is not visible the connection info is...

well, my simple copy paste of your class, and a button to call it returns an error form vb.net;

All i wanted was a string and it's encrypted value, with a...