bfuchs
asked on
Unknown tables found in my sql database
Hi Experts,
I Realized some tables that were recently created in my database, they all have the same date and time created, wonder if that is the results of a software I was trying to experiment (don't remember doing it that time but a possibility..) or is this the work of a virus or worse (perhaps a hacker..)?
Listing below some of them
dbo.APPLICATION_SETTINGS
dbo.COMPARISON_OPERATORS
dbo.EVENT_COLUMN_SUPPORTED _OPERATORS
dbo.EVENT_COLUMNS
dbo.LOGICAL_OPERATORS
dbo.PROFILER
dbo.PROFILER_EVENT_CATEGOR IES
dbo.PROFILER_EVENT_DEFINIT ION_COLUMN S
dbo.PROFILER_EVENT_DEFINIT ION_FILTER _ITEMS
dbo.PROFILER_EVENT_DEFINIT ION_FILTER S
dbo.PROFILER_EVENT_DEFINIT ION_SQL_EV ENTS
dbo.PROFILER_EVENT_DEFINIT ION_SUPPOR TED_OBJECT _TYPES
dbo.PROFILER_EVENT_DEFINIT IONS
dbo.SCHEDULE_INTERVALS
dbo.V_EVENT_DEFINITIONS
I Realized some tables that were recently created in my database, they all have the same date and time created, wonder if that is the results of a software I was trying to experiment (don't remember doing it that time but a possibility..) or is this the work of a virus or worse (perhaps a hacker..)?
Listing below some of them
dbo.APPLICATION_SETTINGS
dbo.COMPARISON_OPERATORS
dbo.EVENT_COLUMN_SUPPORTED
dbo.EVENT_COLUMNS
dbo.LOGICAL_OPERATORS
dbo.PROFILER
dbo.PROFILER_EVENT_CATEGOR
dbo.PROFILER_EVENT_DEFINIT
dbo.PROFILER_EVENT_DEFINIT
dbo.PROFILER_EVENT_DEFINIT
dbo.PROFILER_EVENT_DEFINIT
dbo.PROFILER_EVENT_DEFINIT
dbo.PROFILER_EVENT_DEFINIT
dbo.SCHEDULE_INTERVALS
dbo.V_EVENT_DEFINITIONS
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you're sure they don't belong to your database and you are no longer using the profiler software that generated them then you should be safe to drop them. As with any substantial change I would recommend making a backup prior to any changes "just in case".
ASKER
I have also a database that was certainly created by experimenting a software ( db name ignite_repository) can I just right click on it using ssms and delete?
one more database that I am not sure what's doing here at my server named AuServer, can I sent all them to trash?
one more database that I am not sure what's doing here at my server named AuServer, can I sent all them to trash?
ASKER
Hi BriCrowe,
Please confirm that is ok/not ok to delete those databases so I can finalize this issue.
Thanks,
Ben
Please confirm that is ok/not ok to delete those databases so I can finalize this issue.
Thanks,
Ben
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, I was thinking of renaming them to see if that doesn't cause any trouble...the way I actually do when I am in doubt of any object,
Thanks for your advise
Ben
Thanks for your advise
Ben
ASKER
So is it safe for me to delete all databases/tables/views etc.. I don't remember creating them?