Thanks, I have a better idea, hire some one to help me, when and if my DB gets that large..:-)

.."Rebuilding indexes, no you can wait for the regular maintenance jobs."...

ME: Like what sort of code does that??

.." recommend to use Update statistics."..

ME: yes I did, thanks

I did the change compatibility code, update stats

All seams fine.

I went from 90 to 100 (ie 2005 to 2008 R2)

Do I need to worry about re building indexes etc,...

Thanks:-):-D:-)

found the solution here, once I knew what to google for

http://www.mssqltips.com/tip.asp?tip=1436

SELECT * FROM sys.databases

sp_dbcmptlevel [ [ @dbname = ] name ]

[ , [ @new_cmptlevel = ]...

Are you responding to my last post? I am confused by your statement, please expand.

If so how to I go from 90 to 100, how does one run code to...

I ran DBCC CHECKDB (myDB)

Result:A after a long list of stuff, I get CHECKDB found 0 allocation errors and 0 consistency errors in database 'myDB'.

I guess all is ok

THIS IS...

,,"That is why you can NOT backup / restore to a lower version"..

This is exactly why this thread exists, I learned that the hard way !

Runng DBCC code now !

Thanks:-)

Thanks, but in my first post I clearly state that the server is fine, it is 10.50.1600.1 or MSSQL 2008 R2.

So the code you posted confirms the server, thanks.

So the...

ok thanks:-)

Ok thanks, I guess from why you say this is my step by step process

1) Run .bak backup files of my MSSQL 2005 databases

2) Install MSSQL 2008 R2 64 bit

...This...

Sorry I didnt make setup all that clear.

The server: My laptop, Windows XP SP3

Edition: Enterprise, MSSQL developer 2005

Type: 64 bit

Current namespace: MyLaptop ( ie thats where local goes to)

CPUs: only...

Sorry wayne where do I put CHARINDEX('//',URLs)+2

Can you show me the full select thanks

Thanks:-)