Hi Chris

You can Script Database and its objects and run on a SQL2005 server, as per steveb, then import data form SQL2008 database to your SQL2005 database.

Mathew M.Varghese (9/16/2010)

---

Hi Ali,

Errors was in SQL 2008 and i Install Service Pack 1 in Sql 2008.

My Sql 2000 have Service pack 4 and i took backup from Sql...

hi...

smith.liu328 (9/17/2010)

---

I have installed new SQL Server 2008 R2, when i tried to conenct to the database engine from Mangement studio, i found many instance name not exist.Although i could...

Hi

nivas

Unfortunately that's not enough information. To figure out what the problem is, you have to log into the database server directly (RDP, console, etc...) using the SQL Server service account,...

Hi Gail

Really good explanation as ever.

Hi

Joe

If U find the things in Ur Pocket, why ask to another? First check Ur pocket (SQL BOL) please, the forum's expert not free for answer a silly question.

Gaurav-934012 (9/16/2010)

---

Hi,

I have SQL Server in one of the co- location. I tried to copy the back up from this co-location to my work place server.

When I try to...

Jeff Moden (9/16/2010)

---

PaulB-TheOneAndOnly (9/16/2010)

---

Ali Tailor (9/15/2010)

---

I'm a MCTS SQL server 2008,on 10th sept 2010, Having 5 + years working experience in IT as 'Software Support Engineer' my Job involve Software...

Hi Jeff

Thank for suggestion/s.

HI

agree !!!

don't use Ready made made Ur ready.

Hi

U can also Use

select * from XYZ into XYZ_MOCK

Hi All

U mean, Install SP1 on SQL 2k8 b4 restoring Backup off SQL Server2000 database, Am I right?

Hi

All

Pls let me know, SP1 to be install on SQL 2000 or 2008.

Hi

Its very impotent that what type of query U will fire against the table 'Foo', on the basis of query type U may decide the which index is best for,