Thanks Paul.

I modified my initial question to make more sense. See if it has enough information to better convey the problem.

thanks,

_Ub

Thanks handkot.

This comes very close to what I want to do. But I still need to have two SELECT statements to run different JOINs to get different results.

One select...

Thanks, I'll keep that in mind.

GSquared (2/11/2010)

---

_UB (2/11/2010)

---

Thanks GSquared. I'll keep those questions in mind, while I think about a solution.

Be it VM or not, the ID must be unique....

Thanks GSquared. I'll keep those questions in mind, while I think about a solution.

Be it VM or not, the ID must be unique. Even if the database is transferred from...

Edit: Sorry again, this is duplicate too. I got an error when I first submitted my response. So I submitted more than once, until I got a success.

Edit: Sorry this is a duplicate post.

Thanks for the response.

I've considered this idea before and while this comes the closest to the solution, I am not sure if this fits for all the senarios. There are...

Thanks GSquared.

I'll try to see, if I can explain our situation:

Our software will be installed at various locations in US. We need a way to uniquely identify each...

Thanks for the response.

Looking in the registry sounds like a good idea.... I'll look further into this to see if this helps.

Elliott W (2/10/2010)

---

I agree, *might* work.. Not...

Thanks for the response, but the server name and instance name could be the same, as they'll in in different networks.

Richard M. (2/10/2010)

---

If you assume that you will not have...

Thanks GSquared. I've read this article before and its very informative.

_UB

Thanks for the responses.

Just out of curiosity... is there a name to these approaches. Like, I was told Approach #1 is called as "Trans. Log Auditing" and Approach #2 is...

I had the same problem before. I am no where close to the way these people (Brian knight, etc.) recollect all the built-in tables/views/columns, but I set out a goal...

After I wrote all my thoughts into this question/post and re-read it, approach 2 seems like a better one. The small over head is negligible. Is one more row per...

This works......

SELECT REPLICATE(CONVERT(VARCHAR(MAX), 'a'), 9000)

REPLICATE must be run under the VARCHAR(MAX) mode to return more characters.

I knew this, but still did the same mistake. I hope I do not do...