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 |
|
Dietrich
Starting Member
2 Posts |
 Posted - 2001-12-26 : 14:57:36
|
| I'm using the DTS to transfer data from one SQL7 database to another...Before doing the transfer, I deleted all the tables/views from the Destination database...I got errors that system objects cannot be deleted, which is fine...however, after the import, I noticed in my Views that there was a discrepancy of 3 Views, being:sysalternatessysconstraintssyssegmentsI've got 2 questions:1. What is the definitation/function of these Views2. Is it vital that they be re-created, and if so, how do I do that?Thanks in advance for your help,Dietrich |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-26 : 15:47:33
|
| I don't know that these VIEWS are vital, but you might want to recreate them. They should exist in every database including the Master. Because they are views, you can probably just open them in Master, copy the code, paste it into a new view definition in your active database and keep rolling.There might be an easier/better way to recover these, but this is the first thing off the top of my head. You might want to research these in SQL Server Books Online (BOL).--------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be... |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-26 : 16:47:18
|
Wait, what sort of discrepancy are you seeing? You mean the data in those views is different than the data in the same views in your source database? Then the views aren't the problem -- the underlying tables are!Why are you trying to move system objects between databases, anyway?!!!  Beware -- this could really screw up your target DB!!!Edited by - izaltsman on 12/26/2001 16:48:23 |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-27 : 00:45:04
|
| Dietrich you dont have to delete the system table's and views . when a new object is added /modified/exported they are recreated or updated automatically to include the new information about the object(s). Therefore a simpler thing will be if you can create a new database and import only the tables (dont include system tables, views) from the existing databases.you can search BOL for complete information on System tables.Anyway herez some xtract of it.SysIndexesContains one row for each index and table in the database. This table is stored in each database.SysconstraintsContains mappings of constraints to the objects that own the constraints. This table is stored in each database.About syssegments it has been removed from 7.0 version. i think you are using Sql Server 6.5 .HTH-------------------------Graz's Baby is my Master:) |
|
|
|
Dietrich
Starting Member
2 Posts |
Posted - 2001-12-27 : 12:36:40
|
| Thanks a bunch for all your help...I'll give it a whirl...Regards,Dietrich |
|
|
|
|
|
|
|
|
3 system views not importing