Use the Information_Schema catalog views to spit out a table / column list. Adjust the below code as necessary:

SELECT Table_Catalog, Table_Schema, Table_Name, Column_Name, Is_Nullable,

Column_Default, Data_Type, Character_Maximum_Length as ChLen,

numeric_Precision,...

electricity

SQLKnowItAll (1/27/2012)

---

Brandie Tarvin (1/27/2012)

---

SQLKnowItAll (1/27/2012)

---

If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending...

SQLKnowItAll (1/27/2012)

---

If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending on the disaster...

Jared,

Actually, I'm approaching this from the POV of someone who did DR & BC design at a previous employer far far before I ever became a DBA.

It's obvious to...

Reasons why I disagree with Replication as a DR solution.

1) Latency. Depending on your replication setup, you could have more latency in it than in your normal database backups. Which...

I'm reaching, but ... Does this help? http://guomingli.blogspot.com/2010/03/ole-db-provider-sqlncli-for-linked.html

Anybody here backup with BizTalk?

http://www.sqlservercentral.com/Forums/Topic1242925-391-1.aspx#bm1242974

Someone help me. My brain is leaking.

I think I need to stop answering forum questions for the day. My fingers and my head don't agree with each other, and...

Are your backups native SQL backups or are they using BizTalk to backup?

Wait. You're using a Linked Server...

patrickmcginnis59 (1/27/2012)

---

Brandie Tarvin (1/27/2012)

---

If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance jobs and...

Krasavita (1/27/2012)

---

I have a lot of sp and I want provide access to all sp with execute,is there way to select all of them at the same time or I...

GSquared (1/27/2012)

---

Brandie Tarvin (1/27/2012)

---

So, question of the day. How do you help people who refuse to be helped? People who are resistant to your suggestions of "test it" or "try...

That is a...