Brandie,

You are quite welcome. It has been a while since I read a book for relaxation, so why not read something written by a fellow DBA?

Ankit,

The only thing you need to be careful of when having a database in Simple Recovery is that you are restricted to restoring to your latest database backup whether it...

Yes, please send me the information on ordering an autographed copy.

Thanks in advance.

David,

Another great tutorial! I am eagerly anticipating Part 3 of your series.

Samuel,

Thanks for the book reference, I will definitely check it out!

Silly typos!

(I am the typing kign)

*chuckle*

My wife and I both had speech issues when we were kids, a Speech Therapist can work wonders.

(The butterflies in my stomach hit the top of my head when I...

Brandie,

Congtrats to ya!

Do we need to be scanning YouTube for Snoopy-Dance footage?

I will have to exercise my One-Click amazon order button when I get home.

... given the choice or in some sort of weird betting scenario, slap me with the cooked chop!

Mythbusters did an episode where they fired frozen and thawed chickens into aircraft...

Frances,

My apologies for reading the posting too quickly.

All I have been able to find is a reference on page 388 in the ebook:

http://books.google.com/books?id=G2YqBS9CQ0AC&pg=PA388&lpg=PA388&dq=sql+server+enable+remote+connection+-2005+-desktop&source=web&ots=ZuMVFpFUaN&sig=6k4sCuHomxiLX_hDJsL95FRc31E#PPA388,M1

After executing:

exec sp_configure 'remote access',...

Note that anything you write will need to be using Oracle SQL syntax and/or pl/sql, not sql server-based t-sql. All SQL Server (or the DTS/SSIS package) is doing is...

Jeff,

I *have* to know ... Are the pork chops frozen, thawed or cooked? (I am thinking the chop consistency is situational, and if so, please elaborate!)

If you are working with SQL Server 2005 and used the "SQL Server Surface Area Configuration" Tool ...

Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools >>...

I will second Samuel's warning about the SSIS learning Curve! Do your self the favor of learning the fundamentals of how to build your dtsx packages properly.

There is just...

Scott,

Thanks for sharing the code. Nice Report!

Happy T-SQLing

Ankit,

I agree with the other recommendations to put the database in Simple mode and make a backup job that will backup your database when your feeds are completed. The...