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

Thanks for the info. Is there something you'd like to see? Hopefully we'll get around to adding some sort options here over time.

Doh!

Actually you are correct, but we have other constraints, bandwidth, money, and you guys hammer the bejeezus out of this place. We're averaging (5...

We've talked about this before. I think points only accumulate for the first day (before the next newsletter) and then it's just a learning thing. However with the site cutover...

This is a good idea. I'll get it on the list.

select @@version

good luck

Thanks for the feedback Chris!

No books I know of and I'm sure MSDN should have something on redistributing and wrapping in an installer.

MSDE functions the same as a SQL Server, so once it's installed...

run the scirpt from isql/oswl in the command line. /? will give the options, which to a file is one.

If you need to schedule this, SQLAgnet can run this as...

What are the info schema views lacking?

We'll add it to the list.

If you have trouble shrinking, try this. http://www.sqlservercentral.com/scripts/contributions/26.asp