Hi Everyone,

Thank you for your replies, yes, having read your responses, I'd say doing it at the presentation level does indeed make total sense. I think I was...

Hello,

Thank you for replying, no afraid not, I'd already checked that, its just the one page.

One think I missed out in my previous posting what that...

If you can remember that far back, what was the other way? I do not understand why you would not try to help others as other have helped you?

Regards,

D.

Thank you Thom, that was exactly the answer I needed, plus a little extra that will help me down the line.

While on a winning streak, I wondered if...

Hello,

Thank you for getting back. The collation in the Dataset properties is set to default.

Regards,

D.

hey,

Well the book is pretty old now, so if you go though the errata I'd imagine a lot of the mistakes will be reported. If you use a pencil, you...

Ian,

I assume your $server object is an SMO server object that you have already created.

If so, this ($Server.Databases.filegroups.files) would return nothing, as Filegroups is a property of an individual database,...

Thanks for the replies here, sorry I have not got back, I did actually work this out in the end. When I have finished the whole project I am going...

Hi Jeff,

If it was just that on its own Id agree, but this is a small cog in a much larger automation scenario.

Regards,

D

Hi Shawn,

Thank you for getting back, I had a read on Scopes, quite a bit to take in for a newbie, but I did try to apply some of the...

Hi Shawn,

Thank you for getting back, the thing I am not getting here is, after I have ran the code and type in $ChooseDBRole [enter], there is no value assigned...

Hi Shawn,

Ok, I've worked out what it was I'm actually after, and I'm almost there. What I was actually after was Argument Completion (unfortunately I didn't know it was called...

Hi Shawn,

Thank you for taking the time to answer. Obviously I've completely misread what I was looking at! However, it has opened my eyes to possibly using a form for...

Thanks Shawn, those are two great tips! In the end, mainly because it suites my environment, I wrote a FN for the start and end that started, then stopped the...

I did indeed, sorry for the late reply, I've been away. I had to add in some variables which sorted it. Here is the relevant bit of code I ended...