It's depend on the size of your database, nature of your database i.e. transactions, Recovery model of your database, frequency of your T-log backup etc. As a thumb rule if...

Howmany rows the specific table contain? what is the size of the table?

Make sure the OS Backup is not conflicting as it folder is accesse by other os backup than also SQL Server won't able to delete the file.

Above link is working fine just eliminate period (.).

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

You can refer the following link for reference:

http://www.sommarskog.se/mssqlperl/unix.html

HTH

If I am not worng

sp_OASetProperty

will work in 2000 too while sp_send_dbmail is available from sql 2005 onwards. Hence this will have more flexibility with respect to version.

I am not sure to consider this question as good or bad?

But the fact is I have fixed the syntax and opt for answer 1 and lost 3 points.

Here is...

You can also use DBCC SHOW_STATISTICS

Check the ALTER AUTHORIZATION (Transact-SQL) which may help you. Refer the following link:

http://technet.microsoft.com/en-us/library/ms187359.aspx

HTH

Hello Paul

Perfect Question!!!

To be specific I like the Answers provided are superb.

Anyway I pass it 🙂

Cheers

You can also set up to send mail with required information as soon as DDL trigger fires.

I hope as a DBA no body is doing like this deliberately. But it's...

refer the following link which might userful:

http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx

It is not advisable to update the system tables.

You can shrink tempdb

dbcc shrinkdatabase (tempdb, 'target percent')

this will shrink tempdb. Also you can use dbcc shrinkfile to shrink primary or log file.

Refer the following link for tempdb:

http://technet.microsoft.com/hi-in/library/cc966545(en-us).aspx#EBAA

HTH

looks like some of the supporting services are not running or not enabled...

check the services "Remote Desktop Help Session Manager" is running