mbender (6/15/2011)

---

These servers are heavily intertwined with views and functions and asp pages. Is there a easy way to move the database without us having to rewrite everything? Any...

Table DDL (creation scripts) and sample data would be helpful.

j.a.c (6/15/2011)

---

What I have heard from sources close to the change is that SQL Server doesn't have the HA capabilities, nor can it scale enough to meet the demands required...

Thou shall not cross post.

Thou shall listen to Gail's answereth.

http://www.sqlservercentral.com/Forums/Topic1125549-149-1.aspx

here's a link on the migration. Read on down and you'll find a piece on the DTS->SSIS migration wizard. That's probably what you want.

Think that's a MS typo? That page references SQL Server 2008 versions and breaks down the free editions into compact and express. Compact lists...

I see, you probably saw that SQL Server 2008 R2 Express has a 10gb limit.

4gb max size on SQL Server 2008 Express edition.

Can you site the 10gb claim?

even if there were... they (those with lots of posts) couldn't tell us or we would have to be deleted!

What do we win? more SSC...

meh...

Yeah, I heard about it last night during the indians/yankee game.

They mentioned talk about a bye-week for the top team/top # teams while wildcard series are played out.

I don't know...

Sorry Deorca 🙁

Learn from this as Gail said. Make sure you have a solid backup strategy in place. Run checkdb regularly to catch this corruption asap (hopefully never again).

If you...

Hopefully Gail sees this. She's a super corruption fixer.

She'll probably say to not do anything until she gets a good look at the error that DBCC checkDB returns (with no...

select vendor

,shipto

,weeks

,product

,amount

,vendor + '_' + shipto + '_' + CONVERT(varchar(20), current_timestamp) as Reference

from product

where weeks = 1

thanks for the DDL scripts.

Is this close to what you needed?

Woo! And I thought I would never need the NUMA knowledge obtained a few days ago.

Thanks Gail/Steve!