Monthly Archives: June 2015

List MSSQL instances installed in server using COmmand Prompt

use below command in CMD prompt to get the list of MSSQL instances in server. Servers: test_User1 test_User1\MSSQLSERVER1 Note – ‘L’ is capital letter in above Command.

Posted in Uncategorized | Leave a comment

MSSQL Replication – Interview Questions

MSSQL Interview Questions  Installation Where will you find the SQL Server installation related logs? Installation related logs are stored under the shared feature directory folder which was selected at the time of first SQL Server instance installation.  E.g. If Shared … Continue reading

Posted in Interview | Leave a comment

T-SQL to start/Stop SQL services.

— to start/stop service using SSMS –See below example to check non-SQL Service excellent article by author here!! http://www.mssqltips.com/sqlservertip/2036/monitor-start-and-stop-sql-server-services-using-xpservicecontrol/

Posted in MSSQL | Leave a comment

Job failure E-Mail Notification Automation

Configuring the notification for Job failure alerts.  Assumption – we assume that Database Mail is configured. If not familiar with the DB mail procedure. In the beginning of the article its given. Please refer the below link. http://www.orcsweb.com/blog/desiree/how-to-set-up-database-mail-for-sql-server-job-failures/ Follow the … Continue reading

Posted in MSSQL | Leave a comment

Create Blocking alerts & testing it..!!

below is the doc that has step by step instruction to 1) configure db mail in MSSQL. please check the doc attached in below link try t-sql to configure DB mail in this link – t-sql_DB_Mail_creation db_mail_config steps or refer below … Continue reading

Posted in Uncategorized | Leave a comment