Whenever u save the DTS package as SQL Server a job gets created automatically for it. Once that job gets created then u can schedule it as per your convenience.To...

Shiv,

Here is the link for clustering which is absolutely fantastic.

http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

Hope it helps.

Satnam

Andy,

What sort of information are you looking for about the deleted databases?

Satnam

Backing up the database is always helpful to reduce the size of the transactional log file. It depends upon your business requirements and how much data loss is acceptable to...

I have developed a similar sort of script around few weeks back. I wrote it using HTML along with SQL. If u can hold on for some time then i...

Whenever any email is sent through SQL u get a message as "Mail Queued"

U can also check the sysmail_mailitems table present in the msdb database. Alternatively u can check the...

Also, can u let me know the error message and how many disks are there on the server for which u need such alerts?

Satnam

Thanks.

Can u let me know the code?

Satnam

Once the logic is designed then u will need to create a job which will execute the required stored procedure to send the email. The schedule of the job depends...

Uday,

Thanks for the reply.

Sometimes it happens when in Microsoft Outlook u get the email address instead of display name. Just have a word with the member of the Helpdesk team...

Uday,

Thanks for the reply.

Sometimes it happens when in Microsoft Outlook u get the email address instead of display name. Just have a word with the member of the Helpdesk team...

You will need to perform the following:

1. Create a Database Mail Profile(Not applicable in SQL Server 2005 Express Edition). The steps for doing it can be obtained on the below...

Have a look at the below link,

http://www.codeproject.com/KB/database/SMS_message_from_SQL.aspx

I hope it will provide you some help.

Satnam

Just do one thing, set the recipient as some other email address ie yahoo/gmail and so on and then check.

Satnam