more information...

with a single script... add a role to ALL

databases.

thoughts?

multiple result sets is what i'm trying for.

got an idea?

hmm... thats wierd. i never checked it to begin with, but now i know.

many many thanks! this was driving me crazy.

cool.

by the way... is it really this simple to resolve? just to uncheck

the encryption option?

yes. it is enabled actually. should i uncheck this option?

i have to wonder... why is this a problem now. has it always been

enabled by default?

check this out... of course this is exactly what i'm looking

for, and these guys want to charge for the answer.

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21825243.html

well this in particular is on my client work station. get this... i installed

sql on my workstation right, and when i went to register the local instance

i got this...

right... ok no problem.

i can make piece with alot of temp tables.

problem is... there are so many different sets within

the results i'll have to some how manually script in

the different...

if i understand you correctly you are saying that once

a temp table is populated with these values... i can

again run a 'select/group by' statement and the results

will be in seperated...

yeah, but i'm talking more about taking the output that was

already grouped via the select statement, but breaking up

that into different sets.

does that make sense?

if it is possible... how?

oh ok... so all the declare's, set's, and print from the code set

just above it isn't needed at all?

thats great! i've overcomplicated this. don't know why i keep...

juse so i understand...

so you are saying just this:

UPDATE mytable SET mycolumn=STUFF(STUFF(STUFF(LEFT(mycolumn,23),11,1 ,' '),14,1,':'),17,1,':')

is enough to set the entire columns worth of values to the proper

format AND still maintain...

excellent... works great!

cool! yeah i'm looking it over now.

wasn't sure stuff was an official name, but now i know.

thanks again for the help.

i'm running some experiments with this script.

you...

many thanks veteran,

i would have to run this for each and every record that contained

the date like it is.

quick question... when you say (stuff)... thats supposed to be what

exactly?...