Administer was not listed, and I'd forgotten about it. I've awarded back points and changed the question to reference database level permissions.

Excellent and thanks for the offer. Submit it on site and we'll get you feedback.

Eric M Russell (11/12/2014)

---

When I first saw the title "Double Up During Trips", I thought it was going to be a post about how to save money by doubling up...

I guess I'd say you're buying 2014 no matter what. That's what's being sold for new licenses.

So, go 2014.

I've got limited knowledge here, but AFAIK, the Windows Cluster moves over those items that are clustered in Windows, which could be SQL Server. If you had an instance of...

chrisn-585491 (11/12/2014)

---

My favorite story of efficiency was the the old AppleWriter that worked in 16k memory (kilobytes for you youngin's ) and could still handle documents that were a megabyte...

chrisn-585491 (11/12/2014)

---

Managers investing in developers??!?? LOL (That's a good one...)

I'm convinced that Steve lives in an entirely different world from myself. 98% of my professional education, knowledge and skills were...

chgn01 (11/12/2014)

---

Thank you for your input. I am agree with you. but... can we refer to this link?

http://use-the-index-luke.com/sql/partial-results/top-n-queries

I think "Order By" just do for "Top (n)" rows not...

You cannot recover passwords. No modern, well designed software allows this. It is a big security hole.

Maintenance plans can work well for trimming older files as well. I like Ola's solution for backups. It works well.

If I Google "SQL Server 2008 R2 Express Edition" the first link is a download from Microsoft. They have made it available.

If you need developer editions, search for those, and...

points are awarded back. #1 changed to be different.

Apologies. The interface for adding answers makes it hard to compare and it seemed like they were different in looking at things....

To use the files for your development, you need the SQL Server service (from the dev site post). That means you need to install SQL Server. You can install any...

I'm with Perry. One of the things that causes problems with DR and restores is usually complexity that you struggle with under pressure. Or someone else misunderstands.

I'd set backups with...

First, I'm not sure if we have a language barrier, but it's hard to understand what you mean as you aren't writing clearly. Please be sure you check spelling and...