you should collect audit login and logout event. also check the security audit event.

you can use performance monitor....DMVs and even third party tools...and also the sql server performance dashboard...

select * from sys.sql_modules where definition like '%proc name%'

this will give you the definition of sql objects...like sps,funcs,views....

also

sp_helptext procname

will give you the proc definition

can you post the configuration details ?

I had a chance to repro the issue. It is certainly not a bug and also there is no need to create a new maintenance plan. Modify the existing plan...

A single job with a step for each database will be easy to handle and it is what i recommend

Carolyn Richardson (12/7/2009)

---

Users only need to be members of the fixed role db_backupoperator to be able to take backups, they do not need to be system administrators, as mentioned by...

yes...u are right...I think that there is no other way...

you can remove the built\Administrator role, though before deleting delete the users in each database related to the above server login and transfer the ownership to new users; also delete...

an abstract from the BOL:

"BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles."

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htm

Mani-584606 (12/6/2009)

---

Could you please advice me on viewing these standard reports from management studio? because when ever I open this reports, I'm getting Memory issues, seeing low virtual memory message...

It is not because of windows 7. It happens to me sometimes with windows server 2003. what I have found is that if you have a query open in ssms,...

mail.lists (10/29/2009)

---

Sqlfrenzy (10/26/2009)

---

I...

kanke (10/26/2009)

---

one example is IndexUsageToSizeRatio and IndexUSageToSizeRatio.

I found a quick way, I changed all case to lower case, the only change need to change is INFORMATION_SCHEMA.TABLE_CONSTRAINTS, which should be up...

I didn't get...