Some things have changed in v2000, so depending on what it's doing, it's possible it doesn't work.

Ta-da!

It's Instant Forum, a rev or two behind the current one.

http://www.instantasp.co.uk/products/instantforum/default.aspx

Sounds like you have a problem creating the database. Does go.mdf exist already? Can you create another db?

SQLAgent needs to connect to SQL Server. It can use it's startup account (and windows auth) or it can use a SQL Server account (SQL auth) you specify.

Need some method to move the backup file to the test server. If you name it the same thing on the test server each day, it makes things easier.

Next...

Freddy,

What version of SQL? It tested out on SQL 2000 RTM and SP3.

Actually DATEDIFF will work for finding the different between two dates. See BOL for formatting.

For the programming, most C# books should show how to work with a result set. As far as stored procedures, try this: http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp

For licensing, you can freely redistribute MSDE for...

Interesting problem. I think what you want to do is loop through a series of departments and call a DTS package to email the results. At least that's what I'd...

Target Server issues: http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp

Did you change the IP on the server? SQL Server listens on startup for the ports and responds accordingly. It doesn't affect the server starting. Something else changed. Read the...

Check to see if the TCP is disabled in the Networking settings for SQL Server. It might have been removed and you can add it back. Also the XP firewall...

Suggest and it shall happen

sometimes.

It's been removed. The forum software didn't come with remove and so it's one of those items on the list to get fixed.

Which VPN? I'm not sure the overhead is substantially worse in one v the other. I'm sure a hardware VPN works better than PPTP in software, but bandwidth is likely...