→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Hemoco
Lansweeper Alumni
To fix this problem open the database scripts page in the configuration tool and execute the following script:

delete from dbo.tsysreports where isnull(reportquery,'') = ''
GO
alter table dbo.tsysreports ALTER COLUMN [reportquery] nvarchar(200) NOT NULL
GO
ALTER TABLE dbo.tsysreports ADD CONSTRAINT
PK_tsysreports PRIMARY KEY CLUSTERED
(
[Reportquery] ASC
) WITH FILLFACTOR = 90 ON [PRIMARY]

GO
0 REPLIES 0