I don't know whether you will be able to do this with configuration alone.

You could do something like

- add a "available for mobile device" flag

- on the server, use a...

I would have to agree with your developers about these issues. They are problems that I have but with no workaround/solution.

Perhaps you could consider stepping back and looking at...

First a correction to the previous post. Replication does not require a table to have an identity column. For transactional replication, all that is required is a declared...

TCP://acer.chicago.local:5022 etc are end points, not SQL Server instances. What instance has each of the end points ?

Easy - just specify the owner for the article (in Article Properties if you are using the create publication wizard). This becomes the schema name when the table is...

I have seen a number of clients who would be much better off if they used a cloud service simply because their local work practices and infrastructure is not all...

You can setup mirroring on a single computer - you will need to have separate SQL Server instances.

I don't think that you can do it between databases on...

You are right - "EncryptSensitiveWithPassword" will encrypt the sensitive items within the SSIS package itself and does not effect external confi items such as the passwords etc in the XML...

I assume that you are really trying to make sure that replication is operating correctly. You can get replication to do the hard work for you. It can...

Tush by ZZ Top. It is the last song we played at band practice last night and it is such an up tempo song - hard to get out...

On the poor performance side of your question - are there any processes that are blocking the snapshot creation ? The snapshot agent does need to get a non...

The message you are getting is a warning message. If everything is operating normally, you would tend to expect that a replication agent (the distribution agent in this case)...

ERROR_PROCEDURE() returns null since, in the contect you are using, there is no procedure that is relevant. You either need to remove this function from you SET statement or...

In my experience, this happens because the Excel OLEDB provider scans the first few rows (from memory 8 by default...configurable by a registry setting) and determines what the most appropriate...

The most common way to get new subscription to transactional replication publication is to use a snapshot of the articles (tables). The snapshot is a bulk copy of...