hi denby,

we try to limit the use of CLR here, simply because it does not seem to be necessary. however, one caveat that i have seen has to do with...

what i find most frustrating is that debugging requires you to be a member of sys admin. now, most developers are advised against doing development as a sys admin, but...

our company headquarters does use a desk rotation for certain job functions because there is not enough space for all the people to work at the same time. so, there...

"Sequel" works for me.

I had something similar happen a while back. We had a vendor product that created a linked server during installation. As such, the process altered the srvid so that select...

That's a good idea, and one I had not thought about previously except when I needed to dive into my own custom management pack. I'm not sure what you have...

All,

The version of the proc I included is incorrect, and I will ask Steve to post a new zip file with the updated code. Essentially when the delete happens based...

Thanks Kathi!

As for your script, why not pass a parameter (say, @use_native = 'Y'), and have the code issue a native backup command, otherwise you would call the litespeed xp...

In SS2K5 they have truned it off by default. You can turn it back on rather easily, and lock it down to specific users as well.

I know, it is not...

This was designed to be distributed, so yes you would have to push this out to each of your servers.

It could be modified to run from a central location, as...

Thanks Mom, always nice to hear from you.