Archive for January, 2012

20 Jan 2012  •  General  •  0 Comments

Microsoft SQL Server 2008: Resetting a SQL User Password

Sometimes, you might run into a situation where you need to reset the password for a SQL user account. The process is quite simple and is described below. Step 1: Open an elevated command prompt and run the following command to stop SQL services: NET STOP MSSQLSERVER Step 2: Next, we will need to start [...]

20 Jan 2012  •  Featured  •  0 Comments

How to set up a transactional replication pull subscription in Windows SQL Server 2008 R2 using SQL commands

In SQL server, replication allows data to be synchronized between two or more databases.  One server acts as a publisher which has a publication subscribed to by servers; the publication specifies what data is to be distributed to the subscriber servers.  In transactional replication, a snapshot of the publication is created on a subscriber server; [...]