Here are a few questions that you may need to answer:

Are there any messages being written to the SQL Log/ SQL Agent Log?

Is the SQL Agent running?

What is the SQL...

I selected option 2 (and only option 2) and was told I was wrong, as I needed to select option 2 & 3. However option 3 returns the results in...

I read the question as if multiple executions of the select statements would return the same result, so I unfortunately selected the incorrect answer.

I think that it would be...

Jack,

We use UNC paths.

In all reality the shares use a $ extension so they are not visible, so the person would have to know the path. Also we only backup...

I'm not 100% sure of what is wrong with your setup, although I bet there are people on here who could tell you.

What we do is to create the folder...

Hi Jeff,

Is this principal of limiting the number of rows for the deletion operation also applicable to updating? I have to update several hundred thousand rows and I want to...

I did discover this, but just typed the code!

Cheers,

Phil

Hi Jeff,

Thanks for that. I must congratulate you on how well documented and well presented your examples are - it makes learning so much easier.

Regards,

Phil

Thank you for your feedback, I appreciate all the help I get from this site and I am particularly impressed by (a) the speed in which I have had responses...

I'm not sure if anyone is interested, but I have a solution (not the most elegant no doubt). Feel free to post comments - I like to learn better ways...

Wow, that was a quick response!

Thanks.

Does this mean that the property is stored in the database somewhere?

Thanks Ramesh, that was exactly what I was looking for!

Thanks once again,

Phil