Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-30 : 11:08:59
|
mark writes "Hi there
I'm using MSSQL7 sp2 on WIN2K sp1. Here's the scenario that i need help with. I have 3 sets of tables called R1_Product, R1_Dept and R1_Price. These tables belong to the user R1 and have unique keys, foreign keys and triggers.
Is there a way to copy the R1 tables for a new user R2 while maintaining the dependencies? Meaning the result will be R2_Product, R2_Dept and R2_Price with the same dependencies that R1 has. Is there a stored procedure in the master database that retrieves information of ALL a table's dependencies?
Your help is much appreciated. Thanks!
Regards,
Mark." |
|
|
|
|
|
Problem Copying Tables