Jeffrey Williams (12/17/2008)

---

I understand where you are seeing this as a problem. What I was trying to show you is that this is not a problem, but instead your...

ALZDBA (12/16/2008)

---

it is not a bug,

it is a limit one must know about.

If you need more than 8000 bytes, you need an implicit convert to varchar(max).

,replace(cast('abcdefghicde' as varchar(max)) ,'cde' ,'xxx')...

Jeffrey Williams (12/16/2008)

---

I guess I am still not clear on what your issue is. If I use the following:

Use tempdb;

If object_id('tempdb..#TestReplace') Is Not Null

Begin;

...

BTW I managed a work-a-round which is to use the Left() function to return the X most characters I need. While this works for my scenario it will not...

Jeffrey Williams (12/16/2008)

---

Jerry - I would convert the column in the query itself. Using the temp table was just a way of showing what database was being defined from...

Thanks Jeff, that's what I needed.

henrik staun poulsen (12/9/2008)

---

Hi,

Yes, that is also a solution, as pointed out on Erlands homepage (see above).

But to my management that was a more scary solution, so it was postponed....

Thanks to all for replying!

Perry,

OK then this may sound like a dumb question but after copying the DB (creating a duplicate) when you change the Logcal File Name would you use a different Logical...

blandry (11/25/2008)

---

In my relatively short life, we have ....

And yet as we blame the CEOs of the three big American car makers for flying to Washington in corporate jets to...

I know some will disagree, especially those use to budgeting a specific way but it's kind of pointless to justify a specific model for budgeting simply because no one model...

Steve

I don't know if this is an option/possible for this website but I did see something on a other site recently that provides the awarding of points when a...

Lynn - I was in the process of...

Lynn Pettis (11/25/2008)

---

Didn't say there was a way to capture that info on shut down, it was an analogy to what you are trying to accomplish. Also, I just...

Definately. This table is as you say...