inquiry

Hot Topic

FTP Task Send error
sorting
Adding an sql table through VS2005
Reporting Services Data Source Types
Mdx Running Total
ROLAP and partitioning questions
I've got a SQL database and I need to see what the data it looks like
Rebuilding System Databases on a cluster
How to create PK in duplicate column?
sp_addextendedproperty gives error as object does not exist

SQL Server

Consuming a Recordset in a Script Transformation
Calculated measure based on field in fact table that is not a measure in cube.
File System Task - Move File with Dynamic Destination Path
Copy annotations out of xml/ dtsx package
Sql server 2005 - having multiple editions
Backup Device vs backup command
SQL Server Profiler Cant Dump To Trace Table
Mirror goes down... Affect client transactions?
How to deploy Semantic Models manually?
Most effecient way to get "previous row" values?

inquiry

I just have a basic inquiry about sql server mngt studio.

I have create about 50 tables under the Master database. i no longer want them there and would like to place all 50 of my tables into another database. The only way I can seem to go about doing it, is to go into the code and change "Use [Master]" to "Use [Quickwire]", where quickwire is my new database name. however, since there are so many tables this is a very tedious process. Is there an easier way...like a copy and paste concept

Please let me know if there is..

Answer this question

inquiry

  • RajDas

    You can copy these tables by using DTS:Copy SQL Server Objects Task. Select the tables that you want to copy in tab Copy.

  • Marzk

    you can use

    the "select into" statement with the 3 part naming convention

    use master
    select * into quickwire.dbo.dummy from dummy -- 3 part naming convention (server.owner.table)
    drop table dummy

    creates a new table at qucikwire named dummy

    and drops dummy from master



  • inquiry
Answer this question