Brandie Tarvin (1/5/2012)

---

I don't...

george sibbald (1/4/2012)

---

am I missing something here? whats wrong with sp_help?

you can look at the code in sp_help to see how it's done if you only want a subset of...

Leeland (1/4/2012)

---

I had pondered on that thought...

My only fear is that you go ahead and get all these different databases set up...and then how they are used isn't decided until...

angel.fernandezj (1/4/2012)

---

So I have the mirror set but i have no clue if it will work? it all depends on the application? I was told that using transaction log shipping,...

Ken Lee-263418 (1/4/2012)

---

Thanks, a blindingly obvious solution, only you need to know about it. I didn't know you could filter the index because the last time I REALLY looked at...

It's been a good discussion and a busy one.

Sounds like you have a plan for moving forwards. I hope we were able to help in that.

mw112009 (1/4/2012)

---

or can some one help me here with this antiquated query.

This works fine. Just that it does not use sys.objects or sys.columns.

what i need is to be able to...

Koen Verbeeck (1/4/2012)

---

Grant Fritchey (1/4/2012)

---

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping...

sqlvogel (1/4/2012)

---

How would...

You can get most of a table definition from sys.tables, sys.columns, sys.indexes, sys.constraints, sys.ImForgettingSomethingButDontRememberWhatItIs.

Play around with those a bit, and you can get enough to generate a Create Table script,...

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I miss anything...

In the case you're talking about, I think your best bet is build a proof-of-concept server, using Developer Edition probably, and test what happens if you have multiple databases with...

If you need tempdb to be able to deal with different collations, you're probably better off with either separate instances of SQL Server, or (probably best bet) multiple virtual servers.

The...

Sounds like you have a stuck transaction in the log file, or a LOT of VLOG files. Are you familiar with the t-log physical structure? http://msdn.microsoft.com/en-us/library/ms179355.aspx

There's data here on...

Is @Trigger an output parameter or does the proc Select it?