opc.three (9/9/2012)

---

MissTippsInOz (9/9/2012)

---

..actually REVOKE is enough I believe. Certainly worked when I tested because it was something I...

..actually REVOKE is enough I believe. Certainly worked when I tested because it was something I thought might...

What do you mean? What are you...

rohaandba (9/7/2012)

---

HI, I already disabled all other backup jobs.

though I have the tran-backup set, I think its all messed up now.

I see only way is to diable the respective ...

Never say never...but there is no way that I'm aware of.

Do you still have the full set of transaction log backups you took? If you do have a set of backups, between the manual ones and the ones that...

Perry Whittle (9/7/2012)

---

post full details into a new thread for more...

Sergiy (9/7/2012)

---

SQL Kiwi (9/7/2012)

---

And that is exactly the problem. My question...

Yes there are repair options but these are not run by default. There are REPAIR_REBUILD and REPAIR_ALLOW_DATA_LOSS options.

Not sure what...

As far as I know, once you revoke VIEW ANY DATABASE from a user then the only DBs that user can see are master and tempdb + any databases the...

Old post revival!! Just wondered how you managed to get this one resolved as I've a similar situation.

Thanks

The count of singleton_lookups is the number of individual row retrievals by key or by RID and, presumably they are happening as the result of scans rather than seeks.

zsafakhah (9/4/2012)

---

Dears All,

thanks for you comments.

My Company bought a accounting software which need "sa" user for config software and need x-cmdShell sp for some actions.

i am DBA of...

mtucker-732014 (9/5/2012)

---

Do I need the gory details? No. Valerie did describe some gory details of what she heard happened to someone else, her article was not lacking in detail in...

oradbguru (9/4/2012)

---

I am merely trying to get feedback on using the DBCC SHRINKFILE EMPTYFILE command, hence the title of my post. I am not referring to my PRIMARY file....