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 Rooney...

This artical also gives some good advice, http://www.brentozar.com/firstresponder/

Try setting the service accounts for SQL Agent and SQL Server Service to local system, restart SQL then change them back to your domain users, make this change using SQL...

Think the uninstall feature for service packs is only available from SQL 2008 onwards, but Anthony is correct in that SP2 updates will be applied with SP4

Using a WMI query may be able to get you that query, not my thing but a quick google may help.

http://www.microsoft.com/en-us/download/details.aspx?id=16978

scroll down for the bits you want hitting the big download button gets you a txt file 😛

Would always reccomend that SQL Server is on its own box, that could be a physical or virtial server. In this case you need to investigate what is using...

Using a WMI query may be able to get you that query, not my thing but a quick google may help.

That could be just a feature of the evaluation edition, its enabled by default on Standard and Enterprise Edition and disabled in SQL Express

anthony.green (5/30/2012)

---

All three of the answers to them can be found on google.

Copy your questions, place them into google and you will get the answer. I have...

I use perfmon, Brent Ozar has an excellent artical on this http://www.brentozar.com/archive/2012/05/perfmon-your-sql-servers-vital-stats-video/, other than that if you have the budget Redgate and Quest have some excelllent tools for this or...

reused

why not create a new subscriber to Server 2 then remove it from Server 1?

Think this is what you need http://msdn.microsoft.com/en-us/library/ty48b824.aspx what are you using to publish application is Citrix? If its AppV and you have lots of applications ensure you have this deployed...

Head up mate, you'll get it next time

Hope everything goes well this afternoon, nowt like seeing your bairn on the first couple of scans its amazing - only passed by...