Thanks a lot for the write-up. I just happened to run into this changing monitoring server problem and with your samples it worked like a charm - much appreciated!
BTW,...

try right-click on setup.exe and choose "run as administrator" - worked for me 🙂

thanks for a useful function, saved me a lot of time recently

great article, i wish you printed it last month when i had to move around 100 GB from one filegroup to another.

Simple answer - no, there isn't, at least in 2005. Maybe 2008...

Is this article from "SQL for Dummies" book? If not, we should open a sub-forum for this kind stuff.

I'm surprised you didn't mention anything about taxes. IMO, it's the main reason people switch to consulting, at least up here in Canada. When you're a full-time employee the payroll...

Developer and Enterprise editions are similar feature-wise. The only difference is licensing. If you're having performance issues running Dev. edition, you most likely would have the same issues after the...

I might be in minority here, but why does everyone have to do the next (2nd, 3rd, 12th, etc.) in his career? I've been asked the same question about my...

Thanks, sounds like a good idea!

Just like I said, no admin access to any SQL server/instance, only "db_owner" in certain databases, can't even run some system procs, i.e. sp_helplogins...

I was hoping to create a script and distribute it to many workstations, but it seems that modifying the registry directly is the only option.

Thanks anyway.

"But a "DBA" without sa? BS!" - it's my reality now

I'm working as a consultant on a SQL7 to SQL2000 migration for one...

I would create a temp table, dynamicaly add ProgramID values in it, index it and then use it in INNER JOIN to eliminate unwanted records.

HTH

The following articles could be helpful as well - 264155, 248407 and 248391. I just had similar issues on one of my dev servers (Win2000, SQL7) when non-sa users tried...