SMS MIF Files and SQL 2000



We currently use MIF files on the workstations for asset management. The MIF
information is saved in the SQL Server table "User_Information_DATA". There
is one column that shows up in this table that should not be there. Is it
okay to remove this column?

We have recently added an SMS server in another city as a child site. The
MIF information gets stored in the table "User_Information_DATA1". We would
like it to be stored with the MIF information for our server in
"User_Information_DATA". Is it okay to copy the data from
User_Information_DATA1 into User_Information_DATA and then drop
User_Information_DATA1? If we do so will the MIF information from the child
site get saved in User_Information_DATA?

Does anyone have recommendations on the best way to handle this?


.