Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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