Craig Farrell (6/27/2011)

---

george sibbald (6/27/2011)

---

I think you have to accept that in most shops devs will own the code but not the environment (and certainly not production). The DBA is...

toddasd (6/27/2011)

---

george sibbald (6/27/2011)

---

...

I think you have to accept that in most shops devs will own the code but not the environment (and certainly not production). The DBA is needed...

personally quite happy to grant view server state rights.

It all depends on how many environments you have and who you share them with as to the level of access. It...

A DBA never owns code, Devs own code, the DBA is responsible for the environments the code runs in, especially prod. Ownership and responsibility could be getting mixed up here.

The...

jvskarthick (6/27/2011)

---

Thanks, I accept what you said. Just I have one quick question is any one using the log reader and whether the Log file (.LDF) stores the user name/...

no its not in a mode where you can do that, without breaking log shipping. As it is a copy of a database anyway there's no need to back it...

take a look at sys.dm_db_index_operational_stats

http://msdn.microsoft.com/en-us/library/ms174281(v=SQL.100).aspx

thanks steve.

did a bit of research and the transaction log holds the SID of the ID that issued the transaction, that can then be matched to the SIDS in the sysusers...

but steve, with SQL logins they would end up with different SIDS and users would be orphaned on failover (and again on failback).

beg to differ, for example:

http://www.apexsql.com/sql_tools_log.aspx

why would there be such tools if it wasn't for auditing purposes, to see WHO did what, so that information is in the log.

Log Shipping

Log Shipping sound like a feasible option but from what I have read this will have the largest performance hit on the server and also on network traffic. Is...

I don't think there is a cast iron way of doing this. a database may only be used once a month or once a quarter

The DMV Sys.dm_db_index_usage_stats lists usage statistics...

p.s. I think the tran log does record who made the change, so a log reading tool may work for you. their technical blurb should tell you.

Must be some interesting...

seconded, thirded, fourthed and fifthed. Not for service packs, nada.

These need applying in a controlled manner at agreed times, backups taken, with testing afterwards and a backout in place.

Service packs...