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.

 

SELECT

@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:

Tables

  • ServerOS
  • ServerSQL
  • TableChangeLog

Stored Procedures

  • UpsertServerOS
  • UpsertServerSQL

Triggers

  • 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.