Viewing 15 posts - 14,506 through 14,520 (of 39,821 total)
Sorry, was thinking of something else when I posted, not SQL Server Audit, as in the feature.
In terms of auditing the SELECT/INSERT/UPDATE/DELETE, a database audit specification will do this, but...
January 9, 2012 at 12:29 pm
Use a script like this: http://www.sqlservercentral.com/scripts/Miscellaneous/65769/
Change the where from a "column like @value" to "datalength(column) = 9"
If you want 9 digit values.
You think you're asking for something simple, but...
January 9, 2012 at 12:24 pm
There is no logging for insert/update/deletes. You can enable SQL Trace, but you are potentially asking for a ton of data.
What are you trying to accomplish? Typically there isn't...
January 9, 2012 at 11:43 am
jcrawf02 (1/9/2012)
GilaMonster (1/9/2012)
Ninja's_RGR'us (1/9/2012)
There was a time I loved fiction, got any books to recommend?Yes
http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/
http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx
We both have 2010 posts as well if you feel like hunting
I threw this to Steve...
January 9, 2012 at 11:37 am
GilaMonster (1/9/2012)
Ninja's_RGR'us (1/9/2012)
GilaMonster (1/9/2012)
Roy Ernest (1/9/2012)
I see lots of comments regarding post counts... Does everybody have a target?
No, no targets here (though I'll take a screenshot of max_smallint when that...
January 9, 2012 at 11:30 am
Jack Corbett (1/9/2012)
Roy Ernest (1/9/2012)
When I get time post...
January 9, 2012 at 11:26 am
Ivan Mohapatra (1/9/2012)
January 9, 2012 at 11:20 am
Although such incidents are certainly sensationalized by the media, I believe you're going to find that it's actually a whole lot less common than folks think.
Everything is less common than...
January 9, 2012 at 9:02 am
Just saw this
bteraberry (1/4/2012)
Anyone against SOPA is either making money by stealing others intellectual property or they are not familiar with what the proposed legislation actually say or both.
I disagree....
January 9, 2012 at 8:59 am
I would run dbcc shrinkfile for the log file specifically, if it grew beyond what I needed. Same for the data files.
You always need to have some free space...
January 9, 2012 at 8:52 am
+1 to Grant's reply and the book.
Standards are only standards within a particular company. There isn't a way that everyone overall would agree with, or has shown to be better...
January 9, 2012 at 8:46 am
Sorry I couldn't help. So many people are going SAAS since it's an easier sales cycle for them.
If I had the LMS, I might look to extend it with custom...
January 9, 2012 at 8:33 am
Rich Weissler (1/9/2012)
January 9, 2012 at 8:32 am
SQL Kiwi (1/8/2012)
Is it just me, or is SQL code prettifying (specifically colours) broken on the site at the moment?
We had an upgrade from Google last week (we use some...
January 9, 2012 at 8:25 am
Viewing 15 posts - 14,506 through 14,520 (of 39,821 total)