If I remember correctly, when the initial snapshot is created, you get to select whether or not the schema and data already exists. Did you select that option? That MIGHT...
I used Transcender as a study tool for my 227 and 228 tests. The most valuable thing I got from Transcender is really taking the time to read the explanations...
This probably isn't of any help, but we use merge replication and when you try to add an indexed view, it crashes replication (known 'problem' with Microsoft). Maybe transactional replication is...
Our second column does not have a fixed number of values. The input is integer, but will be going to a text column. Looks like a stored procedure is our best...
We are currently using the suggestion made, but we were hoping to accomplish it with an sql statement or built-in function (i.e., grouping or something like that), not...