Database mappings are actually relationships between the syslogins table in the master database and sysusers table in the user database. If there is no record for a Windows user...

You are right with your thinking. With snapshot replication, for most of the time there is nothing to do. The distribution agent would periodically check the distribution database...

Easy, peasy. When you create the article, specify "None" for @pre_creation_cmd (when using the sproc sp_addarticle). If you are using the GUI, when adding the article, go into...

Replication comes with a utility called "tablediff" - could be what you need. You will find it in a folder something like

C:\Program Files\Microsoft SQL Server\110\COM

Personally, I use the "Recent Posts-->Posts since my last visit" and"Recent Posts - Posts from last week" a lot. With that and maybe having the "Categories" shown on all...

As far as merge replication is concerned, the SQL Agent Jobs that are updating data are no different to any other client application that is updating data. All that...

Depending on how you configure your publication, replication is quite happy for you to make changes to table structures and replication will make the equivalent change to the subscriber. ...

By default, each statement is a transaction of its own. So, each delete statement is committed before the next one starts.

You can create your own sprocs for use by replication. Have a look at what the MS generated sprocs do (and in particular, the parameter) and then use that...

To find out what versions of Windows are supported, have a look at

http://msdn.microsoft.com/en-us/library/ms143506.aspx (for SQL 2012)

http://msdn.microsoft.com/en-us/library/ms143506(v=sql.100).aspx (for SQL 2008)

You can also use the following:

SELECT Table_Schema, Table_Name

FROM information_schema.tables

WHERE table_type = 'BASE TABLE'

The port number is also available in the SQL Server log - it is one of the messages logged when SQL Server starts.

FYI : I have created a SQL Cluster as per those 3 articles. The PC I used only had 8GB on it and it really struggled when all of...

By default, SQL Server uses dynamically assigned port numbers. You have the option to assign a specific port number to an instance of SQL Server.

You can do...

What edition of SQL Server are you using.

SQL Server 2008 standard edition does not automatically use indexed views. You need to use the hint "NOEXPAND" if you...