Lowell (3/20/2012)

---

a serverside trace for DML changes is very lightweight; if you have it rollover you won't have to worry too much about log file sizes,a nd it may help...

Please provide DDL for the tables, sample data, and DML of your query for us to help.

SQLHeap (3/20/2012)

---

While I agree that limited access is the best answer, I just arrived and am trying to do just that. Until I sort out the security issues, how...

Well... You could prevent it by not letting people have access to production databases who shouldn't or are incompetent 😉

As Gail mentioned, you need to know your company's requirements. For example, our company does not require point in time backups and require a maximum data loss of 1...

dunne.neal (3/20/2012)

---

if i go to configuration manager the only service in the SQL Server Services list is SQL Server Integration Services 10.0

if i go to services.msc

then that is also the...

How can the same user be...

MSSQLSERVER

Start by opening up SQL Server Configuration Manager and verifying that the services are running (SQL Server Service).

michael wang-201906 (3/20/2012)

---

you are right, 10 rows been deleted insert every min.

the reason I do so is, i put all 'open' PO into this temp table, keep updating the status\details...

michael wang-201906 (3/20/2012)

---

thank you , guys:

1. there is no index on this table. because it has been deleted\inserted all the time, and only about total 10 records there, i didn't...

You say "clean a table." What does that mean? Are you deleting records? How many? Please post DDL for the table and DML for the job as...

You can defnitely do this with SSRS. You may need 1 or more subreports, but it is definitely doable. The right would be the subreport.

I just looked at this one specifically... This layout is...

I understand what you mean by laid out badly. ...