another way you can find out how to change the default file location (or any other setting that's modifiable in SSMS) is to open the Server Properties dialog, change the...

here's a post about using SMO from powershell:

http://pluralsight.com/blogs/dan/archive/2005/12/29/17703.aspx

my money says the OP didn't detach first, they just copied the ldf/mdf while the db was still attached.

did you detach before you took copies of the mdf/ldf?  if not then they will not be valid.

I suggest you restore from a backup instead, it's a more foolproof method.

Restoring...

You can use a proc to insert data into a table that you don't have perms to insert to directly if you have perms to execute the proc.

that's one...

cross posting is a no-no.

it may not be expressly forbidden by the site's rules, but there's no denying that it is bad form.  ask any regular here or any...

for many methods of constructing a dynamic search condition, read this:

http://www.sommarskog.se/dyn-search.html

Ed: why would you ever backup tempdb?  there's not much point as it's wiped clean each time you restart sql server.

or is this just an example?

this is something best done in your front end app, not in sql server.  sql server is about returning data, not markup/presentation.

Powershell + SMO can be a pretty powerful combination:

http://www.sqlskills.com/blogs/bobb/2006/11/07/SMOAndPowershellBetterTogetherTheScripts.aspx

That's really not that many rows.  I don't think you need to partition with so few.  as for why the inserts are so slow, are you sure there are no...

sounds like what you really want is DROP DATABASE.

Catherine:

0 is not the same thing as NULL.  0 means 0.  NULL means UNKNOWN. 

I have two boxes.  one box contains nothing with certainty.  The other has unknown contents.  It...

Please provide:

1. DDL for tables involved

2. sample data for each table, in the form of insert statements, not simply cut/paste from the results window of query analyzer.

3. expected output for...

my instinct is to have all products in the same table.  Either that, or create a view that brings them all together.  Otherwise you'll continually be writing unmaintainable queries that...