You dont want to actually delete the job, just remove it from the listbox? You dont need to put the stuff into an array before adding it either, should be...

You might also consider not rebuilding all the indexes in one pass, maybe get SQL to reuse some of that extra space. Probably a good case for not trying to...

I use Outlook 2k for the client, have had no problems.

Andy

I would bet shrinkdb does some rearranging - depends on how you shrink, whether you remove space from the end or do a 'compact' operation.

Andy

If you're use MSDE from the beginning you'll save some headaches. I'd recommend you create a constant called Wildcard and set it equal to the asterisk, someday when you upgrade...

As far as a tool, all you really need is a mechanism for applying a standard "alter script". Basically a cursor, whether you use SQL or just code it in...

Is master included in the standard maintenance job? Also, is the slow perf on client machines only, or do you see the same thing if you run EM on the...

Oh man, I see I going to pay for not spending much time on .Net so far! Your syntax looks right as far as DMO...server, username, password. I'll try to...

He will want to use SQL authentication. Basically that means adding a login and a password which he will give to you, then he has to add that login to...

Try @@spid.

Andy

Dont think I agree with you on that one JG. Perhaps I am wrong, but if you just rebuilt an index and kept the old stats you'd have a total...

Thanks for the follow up - sorry we werent able to help you on this one!

Andy

I've got some code in a one of my DMO articles you can use - the listservers method...is oh, unusual - doesnt quite return an object.

Andy

I dont think so.

Andy

I'll admit to being constantly puzzled by their licensing also. I leave it to our admin to figure out so far! I'll see if I have anything about it at...