mike 57299 (1/26/2011)

---

Ok, now what if there is not a rank. What if the color is ordered by the way it is entered. How could I get the...

Why do you want to avoid replication? Seems like a push or pull transactional replication is what you are looking for.

matt stockham (1/27/2011)

---

nadabadan (1/27/2011)

---

DECLARE @v-2 varchar(max)

DECLARE @t varchar(max)

SET @t = 'abcdefghij'

SELECT @v-2 = REPLICATE( @t, 10000 )

SELECT @v-2

If you copy and paste the value...

matt stockham (1/27/2011)

---

nadabadan (1/27/2011)

---

matt stockham (1/27/2011)

---

All valid techniques, but if you just want to see the content of a long field then the easiest way is to copy the value...

matt stockham (1/27/2011)

---

All valid techniques, but if you just want to see the content of a long field then the easiest way is to copy the value (ctrl-c) from the...

thisisfutile (1/27/2011)

---

In the article, Jeff stated "I don't really care where the line "wraps", nor do I care about trailing...

"t.N BETWEEN 1 AND LEN(@LongString)/@length+1" would list an extra blank row where LEN(@LongString) is a multiple of @length.

DECLARE @longString varchar(max)

DECLARE @val varchar(max)

SET @val = 'abcdefgh'

SELECT...

Could be that the publisher and subscriber table has different table schema. Specifically, subscriber's table probably has a smaller column data type than the publisher's. E.G. : if the Publisher's...

I'm betting that you dropped/created the sp in the wrong database, perhaps the master database.

Brandie Tarvin (9/29/2010)

---

If you're replicating over to Server B, then don't replicate the procs in question. Script them out someplace else so you can easily run them on Server B...

Lynn Pettis (9/29/2010)

---

nadabadan (9/28/2010)

---

CirquedeSQLeil (9/28/2010)

---

You will need to go proc by proc and deny execute to the users.

Another option will be to modify the app so that read type connections...

CirquedeSQLeil (9/28/2010)

---

You will need to go proc by proc and deny execute to the users.

Another option will be to modify the app so that read type connections are the only...

I will get more detailed in what I want. We have two identical servers ( A and B ). Server A is live and Server B is the failover server....

LutzM (9/27/2010)

---

CirquedeSQLeil (9/27/2010)

---

Very interesting. I have learned something new.

Even with an explicit deny on the table for update, delete, and insert as well as the denydatawriter - the user...

Matt Miller (#4) (2/15/2010)

---

The joys of null!

NULL is not a value, so as such, NULL is neither equal nor not equal to any value. Unfortunately, that also means that...