Eric M Russell (6/4/2012)

---

One question them or perhaps just you would be:

Are we really talking about consolidating databases that currently exist on the same server, or are we talking...

Yes Manu,

I know :). Noted both points.

Jeff Moden (6/1/2012)

---

Yes... there are two that are very important that I've not seen, yet, that need to be asked of the customer.

1. Why...

MysteryJimbo (6/1/2012)

---

Its possible to work around this by using schema's to separate objects. This would require fewer changes in any code. I'd probably consider different filegroups for each...

Hi Mike, I dint understand this line.

ScottPletcher (5/30/2012)

---

I would think that object name clashes would be a potential concern. ...

Thanks friends 🙂

Any more questions?

Suresh, Thanks TON :). It's workingggg...

Thanks Suresh for the reply.

Where do I can do the changes to provide the permission?

Ok Ninja, I'll try that way also. Thank you.

Ron, I was trying to DECLARE a variable in the beginning and trying to get data from the same at the end...

Ninja, Correct. But for me in the actual script almost 62 batches are there. So I tried Ron's solution. If I get the result in a single exec, it will...

Hi Jeff, Thank you. Thank you very much. :Wow:

Jeff Moden (8/3/2011)

--===== Do this experiment in a nice, safe place that everyone has.

USE TempDB

;

--===== Conditionally drop the...

Hi Ninja,

Thanks for that link. I solved the issue by using the "Quirky Update" 🙂 solution. To do that we need the data to be in proper order. We...

Yeah setiv

🙂 OK.

🙂 lol. I like that. But this just clear my curiosity 😀

Assume we do not have...