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_CATEGORIES
dbo.PROFILER_EVENT_DEFINITION_COLUMNS
dbo.PROFILER_EVENT_DEFINITION_FILTER_ITEMS
dbo.PROFILER_EVENT_DEFINITION_FILTERS
dbo.PROFILER_EVENT_DEFINITION_SQL_EVENTS
dbo.PROFILER_EVENT_DEFINITION_SUPPORTED_OBJECT_TYPES
dbo.PROFILER_EVENT_DEFINITIONS
dbo.SCHEDULE_INTERVALS
dbo.V_EVENT_DEFINITIONS
LVL 4
bfuchsAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Brian CroweConnect With a Mentor Database AdministratorCommented:
If you're not sure about a database then you can just detach it.  If something breaks it's a simple matter to reattach the database.

http://technet.microsoft.com/en-us/library/ms190794.aspx
0
 
Brian CroweConnect With a Mentor Database AdministratorCommented:
It was definitely the result of the software you were playing with.  SQL Server doesn't place any tables in the dbo schema on its own.
0
 
bfuchsAuthor Commented:
Hi,
So is it safe for me to delete all databases/tables/views etc.. I don't remember creating them?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Brian CroweDatabase AdministratorCommented:
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".
0
 
bfuchsAuthor Commented:
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?
0
 
bfuchsAuthor Commented:
Hi BriCrowe,
Please confirm that is ok/not ok to delete those databases so I can finalize this issue.
Thanks,
Ben
0
 
bfuchsAuthor Commented:
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
0
All Courses

From novice to tech pro — start learning today.