if you are a student or have a student son/daughter, nephew/niece that is on technology field, take a look at this: https://downloads.channel8.msdn.com/Products.aspx

I actually used the IP address of the server in my script:

Actually, version 9.0.3042 is the original SP2 version that has a few issues that you really don't want to encounter. There is a post-fix available (as mentioned above) that...

In addition to what have been provided here:

http://www.exforsys.com/tutorials/sql-server-2005.html

You can also visit my blog

http://dbalink.wordpress.com

-Marlon Ribunal

I created a similar scenario maintenance plan.

I posted part of my solution in my blog:

http://dbalink.wordpress.com/2008/07/12/how-to-create-dynamic-file-system-directory-in-tsql/

Hope that helps.

-Marlon Ribunal

Download SQL Server 2005 SP2 Version 9.00.3042. You don't need to reinstall everything. Just install the Client Components and Notification Services, and you will be fine.

Download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en...

Hey,

You start from here: http://dbalink.wordpress.com/2008/06/15/find-user-tables-and-their-columns-info-in-sql-server/

-Marlon Ribunal

Dude, you need to Install IIS. SQL Server 2005 have some components that need the IIS.

If you don't know how to install IIS, here is where you can find...

You can always set the idle time to a desired time-limit. Usually this is done for security reasons and not really for performance-related issue. SQL Server 2005 can handle that.

Regards,