The old system grouped by forum, then listed threads by reverse datetime of the last post. We'll get there since I keep bugging Andy as well. I depend on this...

I found it annoying as well, but  changing it in my profile solved that issue. It isn't checked anymore for me.

That's a good one. I'll pass that along though usually authors approach us with topics. However we do have a monthly newsletter for authors only, so we could add in...

Good suggestions. I'll take them into account and produce an updated list in a few weeks.

One thing I want to point out is that I wanted this to be a...

Not sure about the backup and restore ?, but you can use dbcc showcontig to get a feel for the fragmentation in tables.

Check the script library, but this would not be hard. Select from sysindexes, build a command line to rebuild the index, add the clause to move to filegroups and exec()...

I understand, but there is no good way if people want to cross post. I try to delete them if I see them.

You have to have a disk subsystem that is shared between the servers. Each server must connect to it. IF you can do it with IDE, let ME KNOW!!!!!

http://www.microsoft.com/sql/howtobuy/development.asp

Try reinstalling your tools. Works fine here, XP SP1.

Not completely sure what you mean, but you can create a view

create view myview as select * from servera.ownerb.tablec

and then select from this view.

The above solution is what I'd do.

Haven't used it, but these guys (http://www.easysoft.com/products/2002/lotus.phtml) have an ODBC driver.

Both the Guru's Guide (Henderson) and Advanced TSQL by Ban Gan are good books. Kalen's Inside SQL Server is a must as well. For practical stuff, Brian Knight's SS2K for...

insert #Test2 (account, volume)

Select      Account

              , 1 As Volume

From        #Test1

Group By  Account