You might look at:

http://www.sqlservercentral.com/Forums/Topic764448-146-1.aspx

I've done what you are talking about in only a slightly different way.. What is your source control system? I have primarily used VSS and...

Are you capturing when a package starts only or when it starts and ends. I'm wondering if it is taking 20 minutes to complete that package..

CEWII

update T1 set entrydate = '2009/08/19 06:00:00'

OR

update T1 set entrydate = DATEADD( hh, 6, entrydate )

CEWII

First Kay, I am, going to call into question the source control approach, SQL objects ought to be in ... SQL Servers.. I am curious what the justification is...

vkelman (8/20/2009)

---

You know, in real circumstances, there are many developers. One developer checks for both NULL and zero-length string, when writing a comparison in SQL, another forgets. Although shouldn't be...

Jeff Moden (8/20/2009)

---

You need to go back and look at my code then. I've not suggested the creation of every possible IP address.......

Pretty much.

http://msdn.microsoft.com/en-us/library/ms190673(SQL.90).aspx

"AWE is not needed and cannot be configured on 64-bit operating systems."

CEWII

Well said Jean-Sebastien, well said.

CEWII

The more I've thought about this the more I wonder why this is needed, the application or the stored procedures that write the data should be checking this at the...

Neither PAE or AWE have any effect and are not needed with 64-bit.

CEWII

No you can't.

You only need to break out the flows that are dependent, so unless you have some huge chain of table relationships, you will probably end up with 3-5...

I *might* accept limited t-sql knowledge from a jr DBA, but NEVER from a Sr. Basically if the GUI can't do it, then neither can you. Also, what...

Is this something you do a lot?...

The methodolgy is the same regardless of the source. Try to find a column that reflects a date that the field was last changed in any way, if you...

Is the archive on the same server? If so, Steve has the right approach. If not it gets more complex.

One note: if the schema changes you have to...