Corruption usually occurs from some hardware issue. A voltage fluctuation, a bad driver, some anomaly that cases the bits written to disk to be incorrect.

You should pass in the user ID as a parameter for stored procedures. This would allow you to better understand what is happening.

you can get the command a session is...

We both do kenpo karate, about 4 years for him. I've studied a few more arts, but this was a good local fit for my son. Lots of Muy Thai...

Definitely not SQL related, but my kid got his black belt today. Very proud of him.

http://www.youtube.com/watch?v=DtIOe4IsUq8

Good point. I'll change the wording to say what the mistake is. Do you think

- writing single row triggers

or

- not coding triggers for multiple rows

is better?

If you have a second server, then I would raise the potential issues, but not too hard. Likely you are protected enough for now.

I would make sure the backups move...

The NULL mistake is that people often write

where a.col = null

instead of

where a.col is null

The multi-row trigger is the same. Developers assume triggers fire once per row, instead of...

You really need to read up on how backups work, but here's the basic theory. Lets' assume you back up on Sat for your full. You then have

- Sat Full

-...

1) Is that all I need to safeguard the database given that I only need to restore, if necessary, to the previous day or am I missing something?

- All you...

Justin 17041 (1/20/2011)

---

I have it not i am using a program that auto populates a data base but it doesn't put data where it should like even though it says...

Thanks, will be interested to hear if it matches the talk.

Add the permissions for full control to the Network Service account for that file or folder. Perhaps they are not there.

Good feedback on this, however I'm more wondering if you think the abstract is well written. Does it make you want to go, or not go, to the session?

Check under Configuration Manager for the instance and see which account SQL Server runs under. Then check the permissions for that account on that folder.

One caveat here, it might be good for some things. So maybe you want your remote application to look up product information from a cloud db instead of coming back...