Microsoft has introduced DDL Trigger in SQL Server 2005. You can use DDL Trigger to fulfill your requirement.

I guess there are no setting from SQL Server side. You need to configure the threshold in the 3rd party monitoring tool. Also you have not mention which monitoring tool...

This topic is really v.good and debatable and having lots of variety of answers

Depend on your interest you do have 3 options.

1. Pure Technical

2. Pure Managerial

3. Techno-Managerial

Check following link:

http://msdn2.microsoft.com/en-us/library/ms174269.aspx

--USE THIS TO CHANGE DATABASE COLLATION

http://msdn2.microsoft.com/en-us/library/aa197950(SQL.80).aspx

--USE THIS TO CHANGE INSTANCE COLLATION

Check following link:

http://msdn2.microsoft.com/en-us/library/ms189794.aspx

As data on Production and Test enviroment is different. You need to reconfigure replication after the restore. If you are sure that there are no change in database design. You...

You would like to map AD login i.e. you would like to use window login alongwith sql server login. The only option for this is use Mix mode security.

Thank you Minaz for your quick reply.

Pl. refer the following microsoft link:

http://support.microsoft.com/kb/307487

For some of your monitoring you can set SQL Mail to send you alert in jobs and for others you can find the SQL scripts to monitor it. Search in...

Have you recorded the growth of the database anywhere? If no you won't get it except check the size of the database backup on Jan 07 and Dec 07 and...

This is happening because you do not have stored procedure sp_msForEachTable in your database nav_sepia to check this execute following query to your database nav_sepia.

select * from sysobjects where name...

Refer following link of SQL Server Central.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

In addition to this if you would like to keep your Tlog size smaller i.e less than 2 gb than while doing DTS and transfering the data commit your transaction...

Hello Raymond,

Here is the simple command which will give you desired result.

xp_fixeddrives

Hope this is what are you looking for.