Viewing 15 posts - 1 through 15 (of 23 total)
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,...
February 8, 2017 at 2:43 pm
try right-click on setup.exe and choose "run as administrator" - worked for me 🙂
May 11, 2010 at 3:13 pm
thanks for a useful function, saved me a lot of time recently
January 4, 2010 at 3:26 pm
great article, i wish you printed it last month when i had to move around 100 GB from one filegroup to another.
January 21, 2009 at 3:31 pm
RPSql (1/14/2009)Is there any way to give different paths for data and Trans.log files while we install sql server????????
Simple answer - no, there isn't, at least in 2005. Maybe 2008...
January 15, 2009 at 8:34 am
Is this article from "SQL for Dummies" book? If not, we should open a sub-forum for this kind stuff.
December 18, 2007 at 11:57 am
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...
November 21, 2007 at 9:33 am
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...
July 16, 2007 at 12:05 pm
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...
July 12, 2007 at 9:28 am
Thanks, sounds like a good idea!
June 26, 2007 at 8:28 am
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...
June 25, 2007 at 8:11 am
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.
June 25, 2007 at 7:28 am
"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...
June 22, 2007 at 3:02 pm
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.
June 22, 2007 at 2:33 pm
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...
May 30, 2007 at 9:54 am