Viewing 15 posts - 496 through 510 (of 687 total)
mbender (6/15/2011)
June 15, 2011 at 7:08 am
Table DDL (creation scripts) and sample data would be helpful.
June 15, 2011 at 7:05 am
j.a.c (6/15/2011)
June 15, 2011 at 6:28 am
Thou shall not cross post.
Thou shall listen to Gail's answereth.
http://www.sqlservercentral.com/Forums/Topic1125549-149-1.aspx
June 15, 2011 at 5:51 am
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.
June 14, 2011 at 1:15 pm
bitbucket-25253 (6/14/2011)
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspxGives 4GB as max database size
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...
June 14, 2011 at 12:38 pm
I see, you probably saw that SQL Server 2008 R2 Express has a 10gb limit.
June 14, 2011 at 12:14 pm
4gb max size on SQL Server 2008 Express edition.
Can you site the 10gb claim?
June 14, 2011 at 12:11 pm
even if there were... they (those with lots of posts) couldn't tell us or we would have to be deleted!
June 14, 2011 at 10:31 am
Steve Jones - SSC Editor (6/14/2011)
Jeter is six hits away, but hurt (http://scores.espn.go.com/mlb/recap?gameId=310613110). Should we have a mini pool as to when he gets 3000?
What do we win? more SSC...
June 14, 2011 at 9:54 am
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...
June 14, 2011 at 7:39 am
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...
June 14, 2011 at 7:08 am
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...
June 14, 2011 at 6:19 am
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?
June 14, 2011 at 6:04 am
Viewing 15 posts - 496 through 510 (of 687 total)