You're correct.

Thanks

Thank you All

All helped.

I finally managed to update the statistics using SP_updatestats.

But, what i noticed, that some statistics were updated, some not. When i right click on some statistics, it...

@@trancount = 0

There are may ways, but so practical and easy one is by using ssms:

right click -> Tasks ->

- Copy Database...

- Import Data...

...

Hi,

Restoring backup is only forward-compatible.

You may achieve your goal if you can upgrade your 2008 version to 2008r2

Regards

IgorMi

Hi,

You can do it with ssis easily, but its your choice.

If I were you I would first make a bulk insert into a temporary table. That is easy and fast....

Nicholas Cain (7/5/2012)

---

I would check that you also have UDP 1434 open through the firewall. This is required for the SQL Browser which gets used anytime you attempt to connect...

No, I'm not using linked server, however...

Yes you can. I, for example, use ssms 2008 for sql server 2005, and ssms 2012 for sql server 2008.

Express version is with some restrictions

http://technet.microsoft.com/en-us/library/ms365247(v=sql.105).aspx

Regards,

IgorMi

Dear all,

Just to remember you on this issue, I still haven't resolved it ...

Any advises are welcome ...

Regards,

IgorMi

I'm sorry my thoughts were different

Hi,

Actually you can check the size of your index. It can be 10%,20%, ... even100% (theoretically) of the table size.

You can use this code

select si.name 'Index Name', sum(sd.used_page_count)*8 'Pages size...

tommyh (6/19/2012)

---

If one wants be really picky "Depends on File System" is actually the right answer.

You can install 2012 on FAT32 and that have a limit to 4GB/file. The...

snigdhandream (6/19/2012)

---

Yes I know, but my problem is... we have a whole DB's tables to be migrated and client is reluctant to creating extra identity columns for DB size issues...

Hi,

If I were you, I would create the new table with identity key + the same structure of the table you're migrating.

Regards

IgorMi