SELECT

DATEPART(dd,MST.backup_start_date)) + '-' + CONVERT(VARCHAR(3),DATENAME(mm, MST.backup_start_date)) + '-' + CONVERT(VARCHAR(4), DATEPART(yyyy, MST.backup_start_date)),'') ,

ISNULL(CONVERT(VARCHAR(100), MST.database_name), ''),

ISNULL(CONVERT(VARCHAR(100), MST.name), ''), ...

U can execute sp_helptext stored procedure name in the msdb database and u will get the required information.

Cheers,

Satnam

U can query the msdb database which contains the tables storing the backup information.

Cheers,

Satnam

High availability solutions are designed so that in case of any disaster the database can be brought back to its original state.

Cheers,

Satnam

Is there any space left on the drive where the tempdb is hosted. I feel that you will most probably need to restart the SQL Server Services.

Cheers,

Satnam

I believe that the distribution jobs gets created automatically when you configure the Replication.

Cheers,

Satnam

Check this one, I hope it helps,

http://www.ebook3000.com/Pro-SQL-Server-2005-Replication_100219.html

Cheers,

Satnam

1 Why not set the auto-growth feature as ON for the database.

2 Regarding SQL Server Restart, the information can be found in the SQL Server Logs or you can check...

Something innovative and out of the box thinking, appreciated.

Satnam

A login is created on the server level. When this login is mapped to the database, it becomes a user for that particular database.

Satnam

Normally, u can set the Autogrowth feature as ON as suggested by Ashish, but in my past experience I have noticed that when the Autogrowth feature is set ON it...

Yes, u can do it. When u right click on database and select Properties , then select Filegroup,it will show you the mdf and ldf file size in MB.

Consider ur...

My mistake, actually in SQL 2000 you don't have database mail profile, instead you use xp_send_dbmail

Refer the books online for the exact syntax for the same.

Cheers,

Satnam

Refer the article below:

http://www.sql-server-performance.com/articles/dba/dml_triggers_multiple_triggers_p1.aspx

For email notification use the below code in the trigger:

exec msdb..sp_send_dbmail @profile_name = 'Profile Name'

,@recipients ='Email Address'

,@subject = @mail_subject

,@body = @mail_body

,@body_format = 'HTML'...

Can you let us know the error message if any?

Cheers,

Satnam