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...

I haven't really experimented with this, though I've thought about it. Much of what I've read in books and from the guys at Sysinternals seems to indicate that this isn't...

I'd like to think that this site is a great resource. There are a number of SQL2K books, I'd pick one up and read it. Read the articles on this...

Are you trying to use Exchange or SMTP mail? Outlook includes the MAPI API, which is what SQL Server uses to send mail.

Basically you want to log in with...