Viewing 15 posts - 7,306 through 7,320 (of 13,460 total)
and an example to save you a trip to BOL:
RESTORE HEADERONLY
FROM DISK='C:\Data\SandBox9090_081010.bak'
June 27, 2011 at 5:56 am
i just checked, and found that you can find the changes in the Application Log of the server.
It doesn't count as a DDL statement, so the default trace doesn't have...
June 27, 2011 at 5:38 am
you can easily add a CLR for regular expressions, so since it's something you can do yourself, i don't think you'll ever see it included in a future version.
search fro...
June 26, 2011 at 10:04 am
george sibbald (6/24/2011)
beg to differ, for example:http://www.apexsql.com/sql_tools_log.aspx
why would there be such tools if it wasn't for auditing purposes, to see WHO did what, so that information is in the log.
george...
June 24, 2011 at 6:27 pm
sounds like you opened the file in Excel, and not a simple text editor;
excel might reformat the presentation of any column to what it thinks is best...
open the csv in...
June 24, 2011 at 2:13 pm
jvskarthick (6/24/2011)
Nice one. Using the server side trace is there a way we can log the data only for perticular user. like the filter we set on SSMS trace file.Thanks,
JK
yes...
June 24, 2011 at 2:08 pm
another thing you could do is restore an old backup and a "today" backup, and compare the tables between the two databases; if any table is not the same...
June 24, 2011 at 1:28 pm
can you create a job today, pull from that view, and log the changes for 6 months or something?
at least you'd be able to answer better with some time...
June 24, 2011 at 1:26 pm
james.massey (6/24/2011)[hrCorrect me if I'm wrong (occurs entirely often), but that only tracks changes and does not pay attention to selects.
it has the last tiem an index had a SEEK...
June 24, 2011 at 1:14 pm
running profiler has a huge impact, but a server side trace has minimal impact;
I have a DML/Login trace, kind of like the default trace, keeping track of the last...
June 24, 2011 at 1:11 pm
james.massey (6/24/2011)
June 24, 2011 at 1:07 pm
if you do not have a trace already in place, you cannot identify who did it;
you can read the log with some third party tools, but the log only has...
June 24, 2011 at 1:01 pm
run this and see if it gets you the info you are looking for...
if a table has not been acccessed at all, it's not on the list; read the article...
June 24, 2011 at 12:55 pm
Garadin (6/24/2011)
I think he 'cheats' by having a big repository of all these code snippets right at hand!Yes I'm jealous =).
guilty as charged i've got an aweful lot of snippets...
June 24, 2011 at 12:38 pm
Sean Lange (6/24/2011)
Excellent. Thanks Lowell. Of course now I have no excuse not to work this afternoon. 😛
there's always work to do in the salt mines...i'm sure. I wanted you...
June 24, 2011 at 12:23 pm
Viewing 15 posts - 7,306 through 7,320 (of 13,460 total)