Log Explorer from Lumigent.

Is this for all logins or one particular one? How are you connecting? Query Analyzer?

Good question. We'll take a look and see. Probably some mis configuration on our part.

That wasn't do bad. I added a new top level forum, moved this under it and then added an administrative forum as well.

FYI, added a Sarbannes Oxley forum.

Thanks for that. As soon as I figure out how, I'll move it over.

You can set the files to rollover after a certain # of MB. You could get look at your files and see what 30 minutes looks like and rollver there....

Joe,

That's a great idea. I'm getting ready for audits myself now and I know I have some questions.

It might be broken right now, sorry.

How big is the db? If it's all cached, not sure the extra $$ buy you anything. If you have complex queries, then parallelism with the extra processors might help...

DEST("field") = mid(source("field"),1,10) or whatever. Same for second dest field.

check the error log to determine the cause.

sp_resetstatus 'dbname'

only if you have some unique identifier.

select a.productid + b.productid + c.productid

 from Product a, product b, product c

 where a.productid = 'A' and b.productid = 'B' and c.productid = 'C'

I haven't had a lot of experience with OODBMS's so I can't comment from experience, but it seemed that they were mainly built to "simplify" db access for developers. Rather...

It could be a bug. Since partitioned views are relatively new, I am not sold that there are not bugs in how they work. We've stayed away becuase of the...