Monthly Archives: May 2014

Powershell – Stopping a Microsoft Windows Service

In this example, l will attempt to get and stop a windows service for say, SQLdefragmanagementservice. First open a windows powershell console, using the run as administrator below. Use the get-process to get the process id. Use the stop-process to kill the windows process/service. Then run the code shown in the screenshot below, modify as […]

Read More

Microsoft SQL Server Merge Replication Client Status Information

Below is a select statement which can be placed in a view, for providing information on core merge replication status information usually seen using Microsoft SQL Server Replication Monitor GUI tool. SELECT TOP 1000 [subscriber_server] ,[db_name] ,SubStatus = CASE [status] WHEN 0 THEN ‘Inactive’ WHEN 1 THEN ‘Active’ WHEN 2 THEN ‘Deleted’ ELSE ‘N/A’ END […]

Read More