Category Archives: T-SQL

Failed Job Notification To Event Log


Earlier, I had written a post about a failed job issue. A friend of mine, after reading this post, asked how should he verify the SQL jobs running in his environment without this notification option? By executing the following script, … Continue reading

Posted in Automation in SQL Server, How To, Jobs, Just Learned, SQL Server, T-SQL | Tagged , , , , , | Leave a comment

Database Files Location


“I have created a database on XXX instance, where are the physical files located?” I saw a similar post today on MSDN forum and thought of writing this short note on it. Here are the few ways to find the location … Continue reading

Posted in How To, SQL Server, T-SQL | Tagged , , | 2 Comments

Database Mirroring with SQLCMD


Finally, I build my script to configure Database Mirroring in High Safety Mode. Earlier, I had written a post on configuring Database Mirroring in High Availability Mode. However, this time, I had written a script to automate the complete process … Continue reading

Posted in Automation in SQL Server, Database Mirroring, How To, Just Learned, SQL Server, SQLCMD, T-SQL | Tagged , , , | 2 Comments