Viewing 15 posts - 7,306 through 7,320 (of 13,469 total)
ok Remi; looks like there is a command line utility called logparser which is designed to read parse/ any kind of log, whether it's iis or windows event logs.
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24659[/B]
so using...
June 27, 2011 at 7:07 am
well i know EXEC sys.xp_readerrorlog 0 works in 2008, but there's other parameters i'd have to look up;
i would swear you could get teh event/error code int he results,...
June 27, 2011 at 6:54 am
Ninja's_RGR'us (6/27/2011)
Plan A would actually be to fix the application in the first place so that...
June 27, 2011 at 6:39 am
doh yeah i see how that could happen;
make it two distinct dynamic SQLS:
ELSE
BEGIN
PRINT 'Column does not exist! Starting Work!'
...
June 27, 2011 at 6:28 am
edit: i'm parroting what Ninja said in a different way...he's too fast!
pujain (6/27/2011)
do you have any other idea to implement this.
yes. don't give access to production.
give the develoepr access to...
June 27, 2011 at 6:19 am
only thing i can think of off the top of my head is a trigger on every table...you could count the rows in the INSERTED/DELETED tables, and compare the ORIGINAL_LOGIN()...
June 27, 2011 at 6:09 am
i have a better question: how do you know, businesswise, you can arbitrarily delete data just because teh table is huge?
wouldn't big tables mean they are busy and in use,...
June 27, 2011 at 6:02 am
ew even worse, the results don't have the version you'd expect, that i can see...it has an internal database version, that you need a secret decoder ring to figure out:
June 27, 2011 at 5:59 am
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
Viewing 15 posts - 7,306 through 7,320 (of 13,469 total)