bwillsie-842793 (7/30/2010)

---

Does SQL Server have an integrated audit function built in? Something that would let you audit changes to particular fields in tables and grab date, time, userid, and...

LOL, that's funny. Actually a friend from the SQL world is coming to the SQL Saturday in Denver, and bringing his wife to meet mine 😛

Some companies in the US...

These events are all free, with limited budgets. You would have to ask each individual organizer...

The Colorado event is in South Denver, #52

http://www.sqlsaturday.com/52/eventhome.aspx

bbop1322 (7/30/2010)

---

Now, if someone wants to share what types of Audits they have setup for HIPAA purposes i would be able to get that promotion, jk, but it would be...

The question was not asking about defaults, so...

I don't think you can. You can set a retention period, but I believe that reuses space, similar to overwriting something on a tape. However it doesn't free up space.

You...

You can restore FROM a snapshot, but you cannot restore A snapshot.

The backup would seem to be trivial. Read pages from snapshot or source db, write to disk.

Hmmm, a suggestions....

Note that I wouldn't recommend this. I'd move each backup to a new file. If you have any issue with this file, and you could over time, you lose lots...

If the data is inside a transaction on the insert, it might not appear until the transaction commits.

It's got to be something in the data. Your test view definition only returns one row, so it's not really a view test.

If you use < and < instead of...

It's got to be in the conversions and the data. You're relying on implicit conversions here. You ought to be using quotes and ensuring the correct date is being used.

Or...

I don't think the exclusion works. Are you post SP2 on 2005? There were some fixes in a couple of the hotfixes after SP2.

There are scripts here to help you...

First, please stop bolding everything. We can read it fine without adding that.

Second, what's the view code?

There is no issue with the index. The SQL indexes do not get out of date like those you manually maintain, or index with something like FoxPro/dBase. They are built...