This project is read-only.

Error with TSQL script

Sep 8, 2010 at 3:48 PM

I am receiving an error when running the tsql script. 

Msg 8197, Level 16, State 4, Procedure trServerOSChangeLog, Line 11

The object 'dbo.ServerOS' does not exist or is invalid for this operation.



@ServerOSID = ServerOSID FROM dbo.ServerOS WHERE HostName = @HostName

Sep 9, 2010 at 3:41 AM

Hello jakvike,

The "ServerOS" table does not exist on your database and needs to be created.  The T-SQL code to create this table is in the iSQLPS ver 1.0.1 download.  So you will have to download ver 1.0.1 and 1.0.2 and run the T-SQL code from both.  Your database should have:


  • ServerOS
  • ServerSQL
  • TableChangeLog

Stored Procedures

  • UpsertServerOS
  • UpsertServerSQL


  • trServerOSChangeLog
  • trServerSQLChangeLog


Let me know if you need any further assistance and have any recommendations to make this project better.  Thank you for taking the time to test drive this project.