When a database is dropped, the jobs remain active in the SQL Server Agent and if a schedule is associated to the job, failures would be reported whenever the jobs are automatically executed. As part of the standard process that I follow whenever I drop...

It finds the Indexes on Database which need to be De-fragmented. You just need to replace 'database_name' with your database name. Include this Stored Procedure in to your Scheduled JOB, schedule it whenever you want. ...

In most of the website you must have seen, the contact us or contactme link at the end. Once you click that it will open a new mail window of your default mail client and it will have the mention subject and a mail id in the to box. So we can achieve th...

To check and provide the ACL of a folder/file you can use below DOS command or the Powershell Cmdlet. To know more about ACL read this : http://en.wikipedia.org/wiki/Access_control_list...

Queue data structure work First in First out basis (FIFO). Its means that the first inserted item will come out first ...

Most of the time we use script to play with folders in production or in local computer, here is a script to housekeep your folder keeping a retention period of required days....

The following TSQL Script makes use of the Dynamic Management Function *sys.dm_os_volume_stats* to retrieve information about the physical disk drives. Please note that this function is available only from SQL Server 2008 R2 SP1 onwards. SELECT phy...

If you want to save your PowerPoint presentation in HTML format and want it to show in a browser(IE) then following code might help you. Please be informed that this may not work for other browsers (other than IE) Read more: http://msdn.microsoft.com/e...

Ever had a situation where you had to attach a database when all you had were the data files? Perhaps when you downloaded the AdventureWorks sample databases from CodePlex? Here's a script to attach a database with just the data files using CREATE DATAB...

...