Copying tables with SQL Server 2005

#**111**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**112**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**113**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**114**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**115**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**116**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**117**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**118**

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it
didn't install the first time around. To install SQL Server Management
Studio which disk should I insert? I tried both disks and each time it
acts like it wants to reinstall SQL Server 2005 which I don't want to do
and so I cancelled. Can I install Server Management without
re-installing SQL Server itself?

Yes. I would start with the first CD, and then select workstation
components only. If you were to select Database Engine, you would install
a second instance.

But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#**119**

You can use the SELECT INTO statement
--BEGIN TRANSACTION
SELECT * INTO Database2.dbo.Contacts FROM Database1.dbo.Contacts

Verify the table
SELECT * FROM Database2.dbo.Contacts

The run the following if everything is correct
-- COMMIT TRANSACTION
or Roll it back if that is not what you are looking for.
-- ROLLBACK TRANSACTION

Samson

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this
easily with the Import/Export function in SQL Server 2000 but have failed
to
find the equivalent in SQL Server Management Studio Express. Do I need
other
software to do this?
Dave

#**120**

You can use the SELECT INTO statement
--BEGIN TRANSACTION
SELECT * INTO Database2.dbo.Contacts FROM Database1.dbo.Contacts

Verify the table
SELECT * FROM Database2.dbo.Contacts

The run the following if everything is correct
-- COMMIT TRANSACTION
or Roll it back if that is not what you are looking for.
-- ROLLBACK TRANSACTION

Samson

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this
easily with the Import/Export function in SQL Server 2000 but have failed
to
find the equivalent in SQL Server Management Studio Express. Do I need
other
software to do this?
Dave