Work for ebay or something?? 

No idea.  Find a query that uses parallilisn.  Run it and catch the plan with profiler... Then check out the exact word to search for.  I'm sorry I can't help...

OHG, never seen a report like that! I hope you summarise the data; I wouldn't want to wait after the printer on that one .

You can make it work like this :

Create a master proc above them all.

Create the temp table in that proc.  Then have that proc call all child processes.  Then...

Here's a good one :

1 - Why are you opening a view and select all of its records?

2 - I hope you're doing that on a developpement box?!?!

Mainly... SMO works both for 2000 and 2005.  So any code you write with SMO will be usable for a very long period of time.  Not sure about SQL-DMO.  As...

Still... why should one timeout and not the other ?!?!?.

Thanx for letting us know about this.

Sounds like a bug with ssms.  I'd check in with Microsoft.

Last time I checked (1 year +).  Wall mart Db was 500 TB.  They had only 5 DBAs .

So 12 gig is still medium-small in...

Is this really how you want to make it?? Why don't you go help someone instead... gonna make you feel a lot better.  Believe me, I've been there 13 times...

May I ask what you plan to do with that information (sure a script already exists around here for that)!

SELECT * from master.dbo.SysDatabases

Lowell, somhow crappy doesn't quite say it for me with this code .

I hope he has some...

Good point.  Can you show everyone a way to generate a seek in a similar situation (dynamic search problems).

SET DATEFIRST 7

Select Datepart(dw, '2006/01/01') --this is a Sunday

--returns 1 on my PC

SET DATEFIRST 1

Select Datepart(dw, '2006/01/01') --this is a Sunday

--returns 7 now.

Just run the correct datefirst statement in autoexec...

Back to the basic problem here.  Why are you calling the same code 400 times in a row to select similar data?  Why can't you query the whole set in...