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 |
|
dragonsting
Starting Member
7 Posts |
 Posted - 2008-03-25 : 08:27:46
|
| Here is my issue:I am using a Software inventory program called SNOW and uses SQL 2000.When cleaning out the inventory (removing the computers) it also needs to be cleared from SQL. Normally we would remove all the PC's and then use this is SQL "spClearInventoryData 1" and that works fine.Except now we need some computers to remain in the inventory. The inventory uses a DB called SNOWDB and LicensemangerDB. All the inventory data is stored in the SNOWDB and is synced with the LicensemanagerDB every night. Except it does not remove the computers from the LicensemanagerDB it only adds info. This is not good because we use a webconsole and that uses the LicensemanagerDB. So even if I clean the iventory that automatically cleans up de SNOWDB it does not clean up the LicensemanagerDB. This results in wrong info in teh webconsole.How can I get the SNOWDB to Clean up the LicensemanagerDB so that they are equal and the same info is available?Please advise |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-03-25 : 09:58:00
|
| Call the vendor and ask them to fix thier software. You might be able to go into the database and fix it so that your console shows correct information, but you may also screw up the application...then the vendor gets to charge you extra for fixing your screw-up. ;)Call the vendor. |
 |
|
|
dragonsting
Starting Member
7 Posts |
Posted - 2008-03-25 : 10:47:30
|
quote:
Originally posted by Haywood
Call the vendor and ask them to fix thier software. You might be able to go into the database and fix it so that your console shows correct information, but you may also screw up the application...then the vendor gets to charge you extra for fixing your screw-up. ;)Call the vendor.
Thank you, I have fixed the problem bij running clearing al the data from 1 DB and then manually synced the 2 DB's with some commands I got from the vendor. |
|
|
|
|
|
|
Clearing obsolete data from DB