Viewing 15 posts - 4,786 through 4,800 (of 8,416 total)
Not sure I understand this one. If the steps have no dependencies, and you want to run every step regardless of the success or failure of a prior step...why...
March 26, 2010 at 9:56 pm
There was an SSC article about this just a few days ago, which you might find helpful:
March 26, 2010 at 9:30 pm
RBarryYoung (3/26/2010)
March 26, 2010 at 9:28 pm
Just to add to George's comments...
According to both the 2005 and 2008 versions of Books Online:
SQL Server 2005 Standard, SQL Server 2005 Workgroup, SQL Server 2005 Enterprise Edition, or a...
March 26, 2010 at 9:24 pm
brett.walker (3/26/2010)
I'm working on the indexing jobs to only rebuild/reorg what is fragmented but I haven't gotten that done yet. The shrink file is (hopefully) a temporary solution.
Hey Brett,
Check...
March 26, 2010 at 9:14 pm
For an ad-hoc requirement, you could set up a Profiler trace on Security Audit -> Audit Database Principal Management Event.
Event sub-class 3 captures user drops.
You could also use an Event...
March 26, 2010 at 8:57 pm
Server names.
One of the best places I have ever worked, had servers named after beers.
March 26, 2010 at 8:28 pm
RBarryYoung (3/26/2010)
*(??? Hmmm, I can never...
March 26, 2010 at 8:26 pm
WayneS (3/26/2010)
(All the while waiting patiently for his article to be written about it...)
Hey Wayne,
The two-part article was finished and submitted to Steve two weeks ago today.
I guess there's a...
March 26, 2010 at 8:12 pm
Wouldn't it be fun if T-SQL were strongly typed?
March 26, 2010 at 12:11 pm
steve-893342 (3/26/2010)
Nice solution Paul.
Thanks, Steve.
As another variation, I have adapted it slightly to a self-contained CTE block without the table function.
Ok. You did notice that it was an in-line...
March 26, 2010 at 11:58 am
CirquedeSQLeil (3/26/2010)
Sad thing is I also put that same quote in slightly different context in that cert thread too - same time.
Not looking ;c)
The email made me laugh.
March 26, 2010 at 11:27 am
CirquedeSQLeil (3/26/2010)
Can't you say anything righteous and hopeful for a change?
Spooky! Just posted that quote on the Random Word thread!
March 26, 2010 at 11:23 am
"Why don't you say something righteous and cheerful for a change?"
(quote from Kelly's Heroes)
March 26, 2010 at 11:21 am
Viewing 15 posts - 4,786 through 4,800 (of 8,416 total)