I have a db and I only really need the table structures and defined functions/procedures from the db. A small sample set would be nice from each table, but not necessary.
What would be the easiest way to accomplish this?
I'm getting the db from a server not connected to the new one so I either need to get the files and reattach or I need to just copy the structure/procedures in.
If all you need is just object schemas, then it's probably easier to just script out the database objects and apply them to your db.
If you don't mind having the data as well, just create a database backup and restore to your machine.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?