if you try and run query analyser through windows...

GSquared (8/26/2009)

---

Titles are like certs and degrees. Some people have them because they reflect a degree of skill, knowledge, experience and wisdom. Some people have them because they...

ok, looking at your screenshots,...

Yep be very careful before you run that on a production box. It can help in extreme circumstances but like Grant has mentioned it impacts on performance considerably.

sivark1 (9/4/2009)

---

my query analizer is corrupted/disabled how to retain back without installing again whole s/w in sqlserver 2000

earlier it was running fine suddenly it is corrupted

pls let me know...

windows is the securest option if you can do it, mixed is a compromise and will in the longterm generate more work for yourself.

you can deny/remove rights to/from the public role, we have had to do that before as part of auditing and compliance.

not really I would say that your sql server had the trigger created by someone/team as part of auditing requirements

Dont really understand what you are trying to achieve here. if you can give more detail

if there is a server backup taken daily, ask your infrastructure/wintel team for the eventlogs for...

BOL is the best resource for the basics, if you get stuck,...

have you checked the windows security log, for the time that it last ran, to try and isolate an account that might have been used to kick off that process....

make sure that when you do this, you allow enough time, so it can be rolled backed without impacting on business use if you have to rollback. also make sure...

Chirag (9/4/2009)

---

Silverfox (9/3/2009)

---

simple, mainstream support for sql 2000 has expired, so unless you pay...

nice explanation crainlee2, very thorough. however I think that you would spend most of your day if not run out of time if you had a medium to large sql...