A more accurate query is...

SELECT

SO.Name

, SI.RowCnt

FROM

SysObjects...

You could try something like

ColumnName LIKE '%[%]'

The square brackets around the second percent sign mean that this one should not be used as the wildcard. Hence, this condition will...

Database maintenance activities are not replicated. If/when you need to rebuild indexes, you must do this on both databases.

As for the performance impact of having indexes on your replica,...

The data pages will be restored to the same place within the file that is was in when the backup ran.

When you create the articles in the publication, you can choose from a number of options which control how your tables and indexes are created on the subscribers. One...

When you have a parameter that allows multiple values to be selected, Reporting Services actually returns the selected values as comma separated list. Hence, the error you are getting...

This is probably occurring because the distribution agent (which is running on the subscriber) does not have permission to access the folder on the publisher that contains the snapshot. ...

Replication definitely supports what you need.

If you are using the replication stored procs, sp_addarticle has a parameter called @schema_option. This is a bit mask of the options...

The biggest problem I see is that your trigger is updating the WAREHOUSE table for every record in the SALES_ITEM table - not just the records that were just inserted.

You...

Why not create a separate publication for the views ?

Dropping objects that are included in a publication is not possible. The DROP commands will fail. You will need to remove the views from the publication(s) first. ...

If you grant access your database using windows groups instead of users, all you would need to do is add the user to the relevant group and you would not...

I would suggest that you have a look at database mirroring instead of log shipping. It is pretty easy to configure and manage and gives you pretty much the...

I sugest that you build a reporting services report with the database and doctor dimensions specified as being parameters for the dataset. Reporting Services usually generates MDX that makes...

A failover will occur when any event occurs that causes a cluster resource to become unavailable. This includes hardware or software failures.