We've been running it for a while now - solid. SP2 is in beta now. You won't be sorry you upgraded. The catch is the price - not cheap.

Andy

Hey Paul, embarrassingly I don't know:-) I believe it's tied to the number of forum posts. I'll see if I can Brian to check for sure in the next day...

Hey Mindy,

It does seem that separate db's would solve the problem. I rarely use filegroups, I'll try to find time tomorrow to experiment a little. Steve, you got any ideas?

Andy

...

Great answer Brian. Information schema way under used!

Andy

Which one are YOU talking about Steve?

Andy

Post your code Wayne, maybe we can help. I know it takes some juggling to get the stupid doubled tripled quadruped quotes right sometimes! I've used it to run selects...

You can run sp_configure 'user options' to return a bitmapped value. If you AND the value with 16384 I think that will tell if the bit is set or not....

Time for the index rebuild depends on amount of data and number of indexes. It's fast, all things considered. If you don't have access, can I assume you're not the...

Why would you need to do that?

Andy

I'm not against blobs always - we use them here on the site for storing articles (but we do cheat and generate semi-dynamic asp pages because we're cautious!). I just...

High memory usage shouldn't be a factor, unless it is so high that you're hitting your paging file. Using ADO, there are two different timeouts - one for the connection...

You would have to remove the foreign key constraint first. Wont matter where you execute it from!

Andy

Lots of things might fix it, I really encourage you to find out why and where it's failing first if at all possible. Investigate the ideas we've offered we first,...

Exactly - thats why you shouldnt use it to start with!

Andy

Not simply. You would have to write the triggers to maintain the view (table).

Andy