• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

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
0
bfuchs
Asked:
bfuchs
  • 4
  • 3
2 Solutions
 
Brian CroweDatabase 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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
Brian CroweDatabase 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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now