VEB (1/29/2009)

---

R.Hensbergen, thank you for your reply.

First, all the applications will be on the same domain as the system with SQL Server is. So only Windows Authentication will be used.

Second,...

Renuka (1/27/2009)

---

Hi,

Using arguments like (REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST| REPAIR_REBUILD), the CHECKDB errors can be repaired. (Check BOL for more info. as these options need to be used catiously. There may be...

I don't know if I'm considered a regular or not. I am on the site daily but not always posting - some days simply perusing the new posts, picking up...

Adam McArdle (1/28/2009)

---

Almost, you missed out a SELECT, see...

Woo-Hoo - 1,000,352 as of this post.

Steve Jones - Editor (1/27/2009)

---

BTW, we've decided to go with a combination of party stuff.

We're donating some rainforest, purchasing 1mm sq ft of rainforest as a celebration. That's a...

And just to add to your reading pleasure, Paul Randal wrote this article. It may give you a little better understanding of recovery. Not necessarily what is right for your...

Something like:???

insert into temp2_sales

select * from temp_sales

where temp_sales.product_number = 0

and temp_sales.customer_number not in (customer_ID from temp2_sales)

tosscrosby (1/26/2009)

---

The frequency is dependent on business needs. Hourly is good but does it meet your needs???

Not a bug that I've...

I found this by Paul Randal, I believe in yesterday's daily newsletter.

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

This is on Gail's website:

http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

A lot of responses to a question like this is the infamous "it depends". You...

We use Tigerzip. The data they provided us has latitudes and longitudes so that when a user plugs in a zip code they can also choose a distance from the...

Mine just "stared".....;)

New in SQL 2005???? 😛

Not if the database that was backed up contained one mdf file. If it had a mdf and a ndf, each under 1.5Gb, you could do it but not if...