notice how the border is different between metaname and dimension, what you want to do is insert columns to the right of that different border and have the element name...

-Removed-

So by command line, I thought you mean with the tsql...well I think I was wrong.

I was looking in BOL about the error and it gave a couple of switchs...

SA for both the source and destination databases.

(I really appreciate the help!)

Nothing in the Publisher, but there was in the Distributor. I got the same error...

Robert Davis (8/17/2011)

---

Look in replication monitor to see if you see a better error. You could also try starting the agent from the command line to see if you get...

Depends on how you setup your replication.

If you have the Publication set to a "drop and Create", then when ever you do a snapshot, you will lose your index. ...

Still room for another player?

I completely agree and appreciate your Editorial today.

Brent Ozar is responsible for me getting into blogging and I love it.

I've found that this summer has been too busy for me...

Jack Corbett (6/10/2010)

---

chrisn-585491 (6/10/2010)

---

++

PASS really doesn't do much for me and I can't even attend the conference. If I'm going to volunteer, I'd...

I'd love to find a smaller way to help out with PASS first.

Right now, I just don't have the time to commit to doing anything large in scale. In...

I won't give you an exact answer, but rather just an idea for a basis to a solution.

What if you were to create a temp table with a set of...

Then yes, you will want to either change the data type of your columns to INT or get the code that is querying against them to use a Decimal datatype.

The...

I was thinking of this last night and there is one spot where it could bite you.

If you have an index on any of those columns that are DEC type...

My take on it is that you've probably got bigger fish to fry.

Having decimal columns instead of integer ones will impact how much disk space the database takes more then...