That depends on if you're going wide or deep with your auditing. Again, I'm just typing stuff off the top of my head, so don't necessarily trust my syntax...

Greg A Goss (12/9/2013)

---

Use those DELETED/INSERTED tables I mentioned.

as a simple example,

"SELECT deleted.column1 from DELETED" would get you the old value while "SELECT inserted.column1 from INSERTED" would get you...

Use those DELETED/INSERTED tables I mentioned.

as a simple example,

"SELECT deleted.column1 from DELETED" would get you the old value while "SELECT inserted.column1 from INSERTED" would get you the new value.

If there's one thing I've learned as a DBA:

Love SQL Profiler and SQL Logs...just because you aren't expecting it to happen or that no one knows that it's happening, doesn't...

That could be any number of things, so I'll start out with a general answer. I'd start by opening Profiler and creating a trace to see what is actually...

That's a pretty general question, but rest easy! The syntax for triggers is fairly simple for what it seems like you're trying to do. BOL and Google will provide...

Not knowing anything about your environment, here are a few suggestions, most of which assume this machine isn't required to be up 100% of the time.

I would do a one-off...

I had to deal with a very similar scenario and came up with some thoughts on the subject.

1) If it is not only important, but is urgent (meaning it needs...

GilaMonster (7/30/2013)

---

Greg A Goss (7/30/2013)

---

1) I write a script to create a new table with the same schema as the "broken" one, and then I'll do an insert into...

According to the output, it looks like it fixed it. Have you run it multiple times and continue to get the notification that it is fixing things?

-G

Without knowing anything about your environment, there really isn't a good way to determine this 100% (unless I'm not understanding your question). The native client drivers are just that...drivers....

I usually have a good enough backup where I can restore a db in its entirety (or to a staging database where I can just pull out the info I...

Also, if you are importing free form text, I find it quite helpful to have a text delimiter, such as a double quote, in addition to a column delimiter. ...

Without more information, it's hard to craft an exact solution. But you can use C# (or any of the .NET languages) to peek into a workbook and get a...

Personally, I lean away from sharing the OS drive with anything. However, with the OS sharing a drive with log files, you run the risk of the logs growing...