Eventually i found that the root cause of this issue is Public Server Role. by default this ROLE should have 'SELECT' but i found that this ROLE as Insert, Update,...

public role is something that i cannot REVOKE for UPDATE,INSERT,DELETE etc................ I am not sure that this PUBLIC role as to do with this issue.

There as to be better way...

This is what i get wheni ran Louis query in that database.

I see all public & no user name under database_principal.

e.g

permission_name object_type ...

aftger going through all systems views & function i am seeing that this user as action = Connect & Select. this one is really confusion to me, when i used...

I got better understanding about C2 audit, but besides trace, do we or can i have customise Triggers in place which can take of the issue that i have. if...

To all replies:-

i cannot take away 'sysadmin roles' from other 3 users, due to stupid mgnt policy. Not sure how C2 Audit is going to help, as i want to...

doyou think that SQL 2005 DDL triggers are or will be helpfull on this matter.

80 compat mode is if certain objects with store procedure are not compat witj sql server 2005 but besides that from logshipping this compat mode doesn't help & only this...

you cannot ship logs from 2000 to 2005 unless you are going to upgrade sql 2000 to sql 2005. once you restore sql 2000 DB on sql 2005 the database...

for 64 bit harware, i will recommend 64 bit SQL server 2005 with atleast RAID 5 & depends on budget you can have RAM. do some web search on Dell,...

is this merge replication & if not then check if those tables primary keys have been removed or ?.

try to see the folder as required permission in which MSDB file resides. some time not having required permission on folder makes database suspect (user\system). i hope this link may...

see the Reports log under LOG folder if it is configured to do so. that will give you some more information or post message from Report logs. thx

see the Reports log under LOG folder if it is configured to do so. that will give you some more information or post message from Report logs. thx

by doing so you are de-associating LDF with MDF. As internally  MDF keeps track of LDF & also create new if you do single file attach(MDF).