still easy to do via TSQL;

you can use the row_number() function to partition the data by those 8 columns.

wrap teh results of that with an outer select where rowNumberAlais =...

could your test server be low on disk space? maybe it's taking a long time trying to allocate disk space to the backup before it can ctually do the restore....

why not just use a set base operation regardless,and exclude anything that might duplicate? by joining the source to the original table, you can automatically exclude them, or find...

hodhod26 (6/27/2011)

---

this data is related to antivirus servers which running from 3 yeares or more we need to delet old data because this size of data make the server so...

yeah, when i look at powershell at first, i have no idea what it does or what it can do.

pure syntax issue...the OUTPUT...INTO goes BEFORE the FROM:

Delete t

Output Deleted.TableTID,

Deleted.Value1,

Deleted.Value2

Into...

oh lookie: you can do it in powershell as well:

i searched powershell read application log...looks a little easier to do:

# query an event (Filter Equal)

# you could change the...

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...

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,...

Ninja's_RGR'us (6/27/2011)

---

Then put that code in a proc and test the front end app to death...

Plan A would actually be to fix the application in the first place so that...

doh yeah i see how that could happen;

make it two distinct dynamic SQLS:

ELSE

BEGIN

PRINT 'Column does not exist! Starting Work!'

...

edit: i'm parroting what Ninja said in a different way...he's too fast!

yes. don't give access to production.

give the develoepr access to...

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()...

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,...

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:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/28/database-version-vs-database-compatibility-level.aspx

---

The...