hmmm check it out.

http://sql-articles.com/articles/dba/installing-sql-server-2005

Do you want to send mail from OS scheduler? If yes then you can use sp_send_dbmail procedure in msdb database, Check http://sql-articles.com/articles/dba/database-mail article

Check this article, this might help you

http://sql-articles.com/articles/dba/intellisence-sql-server-2008

You can achieve this using bcp or BULK INSERT. You can also try SSIS or DTS

Try this script, change your dbname in @dbname variable

DECLARE @dbname VARCHAR(100)

SET @dbname='YourDBName'

SELECT * FROM restorehistory

WHERE destination_database_name=@dbname AND restore_type='L' ORDER BY restore_date DESC

Yogi,

Check this out.

http://sql-articles.com/scripts/table-space-details

Do you configured mail profile? Is it working fine?

Have you selected that mail profile in SQL agent properties?

Have you restarted SQL Agent?

If you want to enable \ disable the jobs through tsql please dont update the systables directly instead MS has provided a procedure to do this in MSDB database. Try...

Check the below KB article to change the authentication mode.

http://msdn.microsoft.com/en-us/library/ms188670.aspx

[font="Verdana"]Selecting the edition depends on the usage you are going to perform on SQL Server.

If you are going for HA solution then you can go for standard or enterprise edition....

[font="Verdana"]If you are using SQL or above you can use Maint cleanup task to delete old backups.

Else you can the above command in SQL server too..

*) Create a new...

[font="Verdana"]It depends on the frequency of DML statements happening in the database. If this is a busy OLTP server then you can do it twice a week else your schedule...

[font="Verdana"]It looks like SQL Server or Instance you are trying to connect is either stopped or it doesn't exists. Make sure its running fine.

TCP\Ip & Named pipes are protocol to...

[font="Verdana"]You can connect to Integration services from management studio, you can see SSIS packages there, right click on the package and execute it.

To schedule the package check the link How...

[font="Tahoma"]I've written a script for full backup some days back, you can try the script. Check the link below

http://sql-articles.com/blogs/2008/06/backup-script-with-retention/[/url][/font]