Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OldZido
Starting Member
4 Posts |
 Posted - 2003-01-15 : 12:01:51
|
| I recently was reviewing some of my databases in MS SQL and found that one of them had been altered. All of the primary keys were deleted and all the Numeric types were changed to Decimal.I use numeric because we use Oracle and MS SQL and sometimes have to migrate between the two.My question is what would have caused this. My thoughts are I did something or an outside user has gotten access.I did transfer some tables between two databases, but not to the one that got altered. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-15 : 12:27:41
|
| You need to check to see who has the permissions/access to do this. It didn't happen by itself. |
 |
|
|
OldZido
Starting Member
4 Posts |
Posted - 2003-01-15 : 12:35:17
|
| Also I use dbartisan and enterprise manager to update my tables. Does anyone know if dbartisan has any bugs. Im reaching here, this problem concerens me |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-01-15 : 12:46:10
|
| LOL you don't think EM has any!Go with tduggan's suggestion; someone (a person) has most likely done this.Jonathan{0} |
|
|
|
OldZido
Starting Member
4 Posts |
Posted - 2003-01-15 : 12:53:26
|
| If anybody knows of any bugs in either programs tell me. I have 15 MS SQL Databases and 20 or so Oracle Databases. Most of them 20+ tables some of them 100+. Im not rulling out someone changed them I just wondering why just the one, why not others. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-15 : 14:42:05
|
| Yes, there's bugs in both programs.Feel better?The bugs did NOT cause the problem you're having though, it was either intentional or accidental alteration of the table by some person. |
|
|
|
OldZido
Starting Member
4 Posts |
Posted - 2003-01-15 : 15:14:33
|
| Useless time to move to another forum. |
|
|
|
|
|
|
Primary Keys and data changed