COPY DATABASE WIZARD

Hello,

I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an

'Copy Database : No such interface supported'

Error and the action terminates! How can I fix this?

Regards

I am assuming you are copying both from and to SQL 2005 based databases? Not sure if Copy DB Wizard will support DMO for the older sql2000 servers.|||

Hi Raaj,

Please take a look at the existing CDW Feedback issues and either add your comments to a related one you see, or post a new Feedback Defect with the following information:

1. Source and destination server versions (8.0 or Yukon), including Service Packs.

2. Whether SQL Agent is running on either source and/or destination, and what version.

3. Whether 8.0 QA is installed on either machine.

4. A repro database attached, to either sp_attach or as a script to run. The smaller the better as long as it exhibits the problem.

We are working on CDW issues for SQL Server 2005 SP2, and are very interested in having good coverage on issues such as yours.

Ed Dudenhoefer

SQL Server Team

sqlsql

COPY DATABASE WIZARD

Hello,

I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an

'Copy Database : No such interface supported'

Error and the action terminates! How can I fix this?

Regards

I am assuming you are copying both from and to SQL 2005 based databases? Not sure if Copy DB Wizard will support DMO for the older sql2000 servers.|||

Hi Raaj,

Please take a look at the existing CDW Feedback issues and either add your comments to a related one you see, or post a new Feedback Defect with the following information:

1. Source and destination server versions (8.0 or Yukon), including Service Packs.

2. Whether SQL Agent is running on either source and/or destination, and what version.

3. Whether 8.0 QA is installed on either machine.

4. A repro database attached, to either sp_attach or as a script to run. The smaller the better as long as it exhibits the problem.

We are working on CDW issues for SQL Server 2005 SP2, and are very interested in having good coverage on issues such as yours.

Ed Dudenhoefer

SQL Server Team

Copy a Table

In MS Access, if I want to copy a table, I can just highlight it, hit ctrl-c and ctrl-v, and VOILA! I now have a "copy of MyTable" pasted, with all data duplicated.

Um. How do I do the same thing in SQL Server 2005? Can this be done with Server Management Studio? I don't necessarily want to copy relationships to other tables, I just want a stand-alone copy of the table, with a new name, inside the same database.

(EDIT): I just noticed I can achieve this outcome with:

SELECT * INTO TestIT FROM TestCases

...and while that is simple enough to get the job done, I kinda still wonder if there is a GUI-oriented means to accomplish this (like Access does), without writing bits of SQL as above.

the closest function of SQL Mgmt. Studio to what you are describing is the import/export wizard (right-click on a a database in object explorer and select tasks/[import or export]. But I dont think it will allow you to specify the same source and destination (you may want "play" with the wizard a bit to ensure you cannot get it to work for you). Outside of that...NO. A related features is that of scripting data, so you could right-click a table and select Script Table As/"Generate Data", I believe SQL tools will have this feature in the future, but I would think other third-party tools already do this, not sure though if this can be done via the SMO model yet or not...

converting to numeric (6,3)

Hey guys,

I am trying to achive the following:

Truncate the values 1680.390000000000000000

to numeric (6,3)

All works ok until i hit a value over 1000, (as above)

The code i was using is:

cos1 = 1680.390000000000000000000

CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3))

I have tried a few others, but nothing seems to work..

I get the following error. "Arithmatic Overflow"

Has anyone got any suggestions?

Thanks guys,

Scotty

A numeric(6,3) would only accept a number as large as 999.999 -six digits total, three digits to the right of the decimal.

Your value, 1680.xxxx exceeds the maximum size and creates an overflow condition -resulting in an error.

Perhaps you need a larger number, like maybe, just guessing here, numeric(8,3)?

|||

Brilliant!!!!

thanks vry much Archie.. this has been confusing me all day,, the way they explain it looks to me as 6 to the left, and 3 to the right...

Thanks again

Scotty