Monthly Archives: June 2015
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.
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
— 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/
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