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 |
|
stuartcrome
Starting Member
1 Post |
 Posted - 2012-03-28 : 01:48:52
|
| I'm doing some work on a pre-existing web site with a SQL Server 2003 back end. For some reason, one of the tables in the database is having its data changed. Instead of normal text characters - which is what it should be - the data is being changed to special characters such as "$", ".", "\" or "__". This seems to be happening every four days or so. I haven't found any scripts or any scheduled automated updates to the database on the site. A solution I am trying is to make the table read-only. Is this a viable solution to my problem? Does anyone have an idea about why this is happening?Stuart Crome |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2012-04-12 : 09:32:07
|
| you can create a DML trigger on the table getting modifed to track the changes. |
 |
|
|
|
|
|
table data being changed