Hi,
I am able to run all my DTS jobs manually, but when I try to run the shceduled jobs for those DTS, they all fail. It seems to be a security issue, but no matter who the owner is of job or dts, the jobs fail.
This has started today as a complete reinstall of OS and SQL Server was needed after a hacker got in to the server and caused havoc. We restored all databases to a point before the hack - everything should be exactly...
Koretex
Last Activity: Dec 19 '07, 12:51 PM
Joined: Feb 14 '07
Location:
-
Scheduled Jobs failing
-
Yep that's exactly it, several of the sql statements were lost, but some still there. It is not possible that it's human factor. Ran checks and all objects are consistent with no other errors. :S
Thanks for the help!... -
It's not data corruption, but actual code being lost. I have to re-add code that was in the stored proc, that is not right. This is a stable stored proc that has been in use for months, but out of the blue loses bit of information....Leave a comment:
-
SQL Server losing sql code in stored procs...HELP!
In the last week, a stored procedure that updates a table used for populating our websites, has lost code for various columns, causing several of our Euro Websites to fall over! I can't figure out why, how, when..in other words I am lost. No-one has changed the sp since it was created, but out of the blue, update statements etc for several columns went missing. Is there a known bug/problem that anyone knows about that could cause this?
No activity results to display
Leave a comment: