Gold Digger, now your talking my kind of tipple, other than that Red Beard, Bank Top Blonde, Bad to the Bone, Sweeney's or Barley to Beer are by far a...

SQLDBA360 (6/11/2012)

---

Tried these last week, imagine the looks you get when you tell folkes that you had 2 pints of http://www.stonehengeales.co.uk/pigswill.html and a http://www.ratebeer.com/beer/bank-top-old-slapper/35536/.

Sounds like a night out wit Wayne...

I'll second that with Waitrose, nearest one is in Manchester city center and is quite small so the selection is limited, other than that the biggest one is in Cheadle....

As Asda have a 2 for £3 deal on ale, I thought it would be rude of me not to pick up a few new ones to try and I...

Thanks for the sample data and expected results, but one thing I would advise is to post them in a consumable format, the second link in my signature block details...

How up to date does the data in tableA need to be for querying?

You could use something like SSIS to copy data from server1 to server2, replication is also an...

Yes, if you have Enterprise licenses and impliment a scaled out deployment of SSRS servers.

You will need to uninstall SP4 and then install SP2. Make sure you backup all databases inc system databases before doing this and have a very large downtime window...

L' Eomot Inversé (6/8/2012)

---

Stefan Krzywicki (6/8/2012)

---

Ugh, just found out we're switching to security that requires you to change your password every 90 days. Nice that we're switching to that now...

everything is written to the transaction log you cannot stop that, it all depends...

What account is your SQL server running as? Network Service? Local System? Domain account?

If possible, change the service account to a domain account as thats best practise solution, and...

Stefan Krzywicki (6/8/2012)

---

anthony.green (6/8/2012)

---

90 days thats a luxury, the company group policies here are typical user accounts get 45 days, and if your a domain admin your password expires...

90 days thats a luxury, the company group policies here are typical user accounts get 45 days, and if your a domain admin your password expires every 14 days.

Daniel Bowlin (6/8/2012)

---

Ray K (6/8/2012)

---

anthony.green (6/8/2012)

---

Revenant (6/7/2012)

---

"This must be a Thursday," said Arthur to himself, sinking low over his beer. "I never could get the hang of Thursdays."

-- The Hitchhiker's...

well if you want to upgrade everything and if you cannot get a hold of media which is built on SP4 then you will need to uninstall and reinstall everything....