If you have SQL Server 2008 Enterprise edition, then look at the new Change Data Capture feature. It depends on what purpose the table will serve in the development environment....

Hey, all the developer needs to do is make sure his SQL basically gets the point...

mtillman-921105 (9/21/2010)

---

Well, we knew that VFP was a dead-end road once it was skipped over when .NET came ou... Hey, wait a minute! When's MS going to include...

mtillman-921105 (9/21/2010)

---

Yeah Eric, I wish I could say that the last line of FoxPro code I wrote was in '98. I waited too long to switch over, but I...

Steve Jones - Editor (9/21/2010)

---

Does that...

mtillman-921105 (9/21/2010)

---

Eric Russell 13013 (9/21/2010)

---

mtillman-921105 (9/21/2010)

---

To what extent were relational DBMS created because drive space wasn't cheap and processing power was weak? Big, flat tables weren't helpful in either...

mtillman-921105 (9/21/2010)

---

To what extent were relational DBMS created because drive space wasn't cheap and processing power was weak? Big, flat tables weren't helpful in either case years ago. ...

Steve Jones - Editor (9/21/2010)

---

... We discarded MySQL and PostgreSQL for this site early on, even when funds were tight, because we weren't familiar with them and they were still...

David.Poole (9/21/2010)

---

The premise of NoSQL is that for applications where data loss is not the end of the world then the overhead of an RDBMS is overkill. They work...

I hope society never advances to the point where an understanding of relational set theory by the average person is required just to get by; most of our parents barely...

Whenever someone requests the creation of a new report, and the specifications don't seem clear or feasible (for example 50 columns fit upon an 11' landscape page), then I'll ask...

SKYBVI (9/17/2010)

---

@ eric

Ya, true , you have to give them a login and permission too.

About the refresh page, there is a option in connection properties,

refresh after __ minutes and also

refresh...

SKYBVI (9/17/2010)

---

Go to excel --> data

data -->other sources

-->sql server

-->new connection

write t sql script there

execute, the excel would be filled with the result

of the t sql specified..

no use of...

If users suddenly report that the database application is unresponsive, and you're looking for a first response script to tell you stuff like what connections are active, what processes are...

Most Oracle developers love cursors. I mean, it's so obvious they're in love. If you read an Oracle PL/SQL developer guide, it will be full of sappy love poetry dedicated...