Viewing 15 posts - 3,151 through 3,165 (of 14,953 total)
Easiest way to do that is an audit table.
Here are the articles I wrote on the subject:
http://www.sqlservercentral.com/articles/Auditing/63247/
http://www.sqlservercentral.com/articles/Auditing/63248/
Make sure to read through the discussions, as there's a lot of good data...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 11, 2011 at 6:09 am
It looks like one before the import, and one after. The one after would have multiple steps in it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 11, 2011 at 6:05 am
Stefan Krzywicki (10/10/2011)
Roy Ernest (10/10/2011)
Grant started and I am scared of heckling him... He looks scary.
He's not scary! If worse comes to worse, buy him a beer after and all...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 2:14 pm
Grant Fritchey (10/10/2011)
GSquared (10/10/2011)
Grant Fritchey (10/10/2011)
GSquared (10/10/2011)
GilaMonster (10/10/2011)
Be nice.YOU'VE BEEN WARNED!!!
😀 😛 😛 😀
She's an ED-9000.... You have 15 seconds to comply... 10 seconds... 5 seconds...
The computer is my friend.
The...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 12:44 pm
The semicolon is a statement terminator and can actually have an affect in terms of compilability of code (specifically with reference to Common Table Expressions), and is listed as "will...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 12:43 pm
Grant Fritchey (10/10/2011)
GSquared (10/10/2011)
GilaMonster (10/10/2011)
Be nice.YOU'VE BEEN WARNED!!!
😀 😛 😛 😀
She's an ED-9000.... You have 15 seconds to comply... 10 seconds... 5 seconds...
The computer is my friend.
The computer wants me...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 12:29 pm
Lowell (10/10/2011)
GSquared (10/10/2011)
Are you just auditing the commands, or do you need to audit the actual data changes as well?
C2 will audit both,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 12:25 pm
The ColumnProperty function doesn't work outside the scope of the current database.
You'll need to use it in-scope, which usually means dynamic SQL to build the query string with a "USE"...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 11:21 am
It depends on what you need to audit.
Are you just auditing the commands, or do you need to audit the actual data changes as well?
C2 will audit both, but it...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 11:15 am
They both will give you errors/warnings about the data, but Arithabort Off will give an error if you use it where it needs to be on.
So, yeah, you'll get more...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 11:11 am
pespes009 (10/10/2011)
Please reply
I already did. Please read my question and supply the data needed. I can probably help you, but I need more information from you in...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 11:08 am
No such thing as a "Select Trigger" in SQL Server.
And they didn't include it specifically to force people who want it to buy the more expensive product. That and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 11:07 am
GilaMonster (10/10/2011)
Be nice.
YOU'VE BEEN WARNED!!!
😀 😛 😛 😀
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 11:03 am
Changes to objects, you can audit via DDL triggers. Search "t-sql ddl trigger" and you'll get the articles on that.
Selects, you'll have to build your own audit solution. ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 9:05 am
Here's the link for the standard needed: http://msdn.microsoft.com/en-us/library/ms190306.aspx
As for why, it has to do with errors vs null values. Read the data I linked to, it'll probably make it...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 10, 2011 at 8:04 am
Viewing 15 posts - 3,151 through 3,165 (of 14,953 total)