I have a DTS package that is scheduled to run each night. The job fails in SQL Agent. I can execute the package through Enterprise manager and also run the job as well without error. Any ideas as to why I can manually run it but it fails when run on schedule. One other interesting note, in...
I have accidentally ran a Transaction to export objects to the wrong database. In doing so I replaced a table that already existed with around 4000 records in it. Is there any way to do a roll back or recover from the .ldf file? I do not have a good back up of this database. I am in big...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.