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...

Lynn Pettis (11/25/2008)

---

Actually, I do have a question about the table(s) that you need to do this for, and it is very generic, how many rows of data in each...

Lynn Pettis (11/25/2008)

---

Actually, you are getting out of the fog. Now that you are getting more into the What is need to be done, rather than how it is...