Copying tables with SQL Server 2005

#91

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

Quote:

I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#92

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#93

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#94

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#95

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#96

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#97

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#98

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#99

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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

#**100**

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?
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
I am not using SQL Server 2005 Express. I have the installation disk
for SQL Server 2005 Standard Edition. Does it not have the 2005 SQL
Server Management Studio like my SQL Server 2000 installation disk? If
not, then that is a downgrade.

The tools ship with SQL 2005. However, if you have a single CD with
SQL Server Standard, you don't have the tools, because they on CD 2.
Which you also should have, unless some did it give you because of
ignorance.

--
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