dbTalk Databases Forums  

Copy a table in SQL Server 2005

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.server Copy a table in SQL Server 2005

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss Copy a table in SQL Server 2005 in the microsoft.public.sqlserver.server forum.



Reply
Page 3 of 10 < 1 2 3 4 5 6 7 8 9 10 >
 
Thread Tools Display Modes
  #21  
Old   
Leon Mayne
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:37 AM





"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Quote:
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.
Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #22  
Old   
Leon Mayne
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:37 AM





"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Quote:
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.
Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #23  
Old   
Leon Mayne
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:37 AM


"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Quote:
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.
Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #24  
Old   
Leon Mayne
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:37 AM


"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Quote:
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.
Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #25  
Old   
Leon Mayne
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:37 AM


"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Quote:
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.
Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #26  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:52 AM


Leon
The OP does not say that he wants the copy in the same db. He just said that
both tables are located in the same db



"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:
"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote in message
news:u3D5IM4VIHA.4532 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.

Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #27  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:52 AM


Leon
The OP does not say that he wants the copy in the same db. He just said that
both tables are located in the same db



"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:
"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote in message
news:u3D5IM4VIHA.4532 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.

Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #28  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:52 AM


Leon
The OP does not say that he wants the copy in the same db. He just said that
both tables are located in the same db



"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:
"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote in message
news:u3D5IM4VIHA.4532 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.

Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #29  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:52 AM


Leon
The OP does not say that he wants the copy in the same db. He just said that
both tables are located in the same db



"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:
"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote in message
news:u3D5IM4VIHA.4532 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.

Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
  #30  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:52 AM


Leon
The OP does not say that he wants the copy in the same db. He just said that
both tables are located in the same db



"Leon Mayne" <leon (AT) rmv_me (DOT) mvps.org> wrote

Quote:
"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote in message
news:u3D5IM4VIHA.4532 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Leon
If the database got corrupted you are still not be able to get back the
table. I think the way to save the datai is having proper backup of the
database or if the database is big, just script out into the text file
the table and keep it on the disk.

Read the original post. They arn't talking about proper backups, they just
want a copy of the table in the same database.



Reply With Quote
Reply
Page 3 of 10 < 1 2 3 4 5 6 7 8 9 10 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top