Thanks.

In a perfect world should'nt the compatibility level also change?

Yes. You can have both on the same server.

or stored procs if u r using them. You have better error handling in stored procs.

Nice article.

After a doing side by side upgrade the databases are moved to the new instance by dettach/attach or backup/restore. Will this change the compatibility level of the database being...

Yes thats right.

Better the design lesser the headaches later on.

Its a general question that you have asked. There are pros and cons for both.Whats the prupose you are trying to achieve?

Pls keep us updated on this.

Thanks a lot everyone. 🙂

Going back to the example i mentioned intially if the log backup size is 2 mb then the amount of data being modified is LESS THAN...

Wont the redgate tool internally using a ETL process?

Using the tool would make it easy for the end user to accomplish the task.

Try this in your test environment.

UPDATE D

SET seqCol = RowId

FROM

(

SELECT ROW_NUMBER() OVER (PARTITION BY FK_ID ORDER BY CreationDate) AS RowId

...

Is the issue solved.

Thanks Jeff.

How about writing the query using UNION .

Jeff Moden (2/25/2009)

---

Hey! By the way, Steve... is there a way to enforce a max width limit on the code windows? Say, at 120 characters so when some...

Iam using RTM version and in that there no need for ".BAK".

Not sure about SP2.