Mh-397891 (7/27/2011)

---

Can I do something like this:

The view is basically selecting columns from orders table.

For example in the publisher:

Create view dbo.Orders_View

as

Select col1,col2,col3,col4 from dbo.Orders

Then...

Distribute a single "dummy" table to each subscriber that has been included in the articles for the publisher "Replication_Dummy" or whatever you want and just send a record every hour...

cengland0 (7/22/2011)

---

Hey, wait a second. According to:

http://technet.microsoft.com/en-us/library/bb510667.aspx

Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies on the...

Am I doing this wrong? (QotD) Even if its a subject I don't know about I try and come up with an answer as its a test of my knowledge....

I just assumed it was NULL. Have never bothered to look in there before (at that stage) and generally our servers have had to be set to mixed mode from...

I can understand people complaining if there was a typo that meant the answer was wrong but to complain that you "assumed" the extra UNION ALL was a mistake,...

Let me see if I have this right...

Server A - Table Orders, new view Orders_View

Publication containing Orders_View as the article (select columns you require via the GUI)

Now what I would...

Misleading but got it right. I took a chance going with 0 as the answer is really that no rows are requested as its an Insert query, but the cloest...

Yep. I learned - "Don't trust what you read on Microsoft's very own website" and "If you read something on microsoft's website - don't take it for granted - track...

Some of these questions really grate my teeth! This one - I have only ever used snapshots in Enterprise. When looking up the syntax an age ago it stated "Only...

I'm thinking that perhaps the database size expanded a lot in preparing for the new index creation (and you say it was a large table) and therefore its taking longer...

hahahah I love my mind sometimes. I just realised I was thinking backwards (early start). My example WOULD fail if you were allowing NULLS, had a null entered, and then...

Just having a look back over older questions (only just noticed the question of the day on newsletters!).

I got this completely wrong but still think I was right at some...

What connection string are you using?

No sorry it defaulted to the D:\prog files\sql\data

The root directory listed under properties is D:\Prog Files\SQL

Default directory under db properties is blank

Model db has log file set to be D:\Prog...