http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

If you are using it on your workstation - why not consider downloading and use SQL Server express which is free.  It has a 4GB size limit and 1GB...

Latest Service Pack release is SP4.

Also look into SQL Server C2 Auditing.

Another simple way without having to detach/attach

1.  BACKUP LOG dbname WITH NO_LOG

2.  DBCC SHRINKFILE (log_name, size in MB, truncateonly)

3.  Take a full backup immeditely and setup trans log backups on schedule.

I do like reading Steve's editorials.  I think they are refreshing and for most  part ( in my opinion) dead on and accurate.  I know it takes a lot of...

Thanks Guys.  Bill - great idea.

If your DB is very transaction oriented, Backup your log regularly.  Make sure your DB is running in full recovery mode. 

If you are not concerned about backing up your trans...

Likely your asp.net app is sitting on the same network and so it can connect.  You are probably trying to connect to SQL Server via QA from outside the network,...

Can you telnet to the port SQL Server is listening on?

Like Prabhi says - check authentication mode.

what error message is the client getting? 

If this is not a live DB then all you need to do is drop the DB, restore the DB again and apply all the relevent trans logs .  If...

Yeah - like Gail suggests above - understand what a master db or other system dbs are used.  Restoring a Master DB is not like restoring non-system dbs.    You need...

Looks like your DB is small enough.  I would run your DB in Simple mode, which would truncate your log on checkpoint and you would not worry about your trans...

if you have set up AWE correctly - then its unlikely a memory issue.

You said you have 4CPU - Do they support hyper threading?  You might consider turning hyper threading...

I agree with Phil using SQL Mail in SQL 2000 sucks.  Looking forward to SQL 2005 which uses SMTP mail.