The easiest method is to use Generate Scripts under the database task menu. If the database is huge you'd want to generate a schema only copy first then import the data. Otherwise you can import the data and schema at the same time.

The easiest method is to use Generate Scripts under the database task menu. If the database is huge you'd want to generate a schema only copy first then import the data. Otherwise you can import the data and schema at the same time.

Don't forget that this approach won't copy TRIGGERs or INDEXs. At least it didn't the last time I tried.

My advice:INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

The easiest method is to use Generate Scripts under the database task menu. If the database is huge you'd want to generate a schema only copy first then import the data. Otherwise you can import the data and schema at the same time.

Don't forget that this approach won't copy TRIGGERs or INDEXs. At least it didn't the last time I tried.

That depends on your scripting options. On the "Set Scripting Options" step you can click on the advanced button. From there you have a lot of choices of what to script and what not to script.

The easiest method is to use Generate Scripts under the database task menu. If the database is huge you'd want to generate a schema only copy first then import the data. Otherwise you can import the data and schema at the same time.

Don't forget that this approach won't copy TRIGGERs or INDEXs. At least it didn't the last time I tried.

That depends on your scripting options. On the "Set Scripting Options" step you can click on the advanced button. From there you have a lot of choices of what to script and what not to script.

My advice:INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

The easiest method is to use Generate Scripts under the database task menu. If the database is huge you'd want to generate a schema only copy first then import the data. Otherwise you can import the data and schema at the same time.

Don't forget that this approach won't copy TRIGGERs or INDEXs. At least it didn't the last time I tried.

That depends on your scripting options. On the "Set Scripting Options" step you can click on the advanced button. From there you have a lot of choices of what to script and what not to script.

It appears that I must not have seen the advance button. Thanks Sean.

You are quite welcome. You even have the option of having it script your data if you want too.