‎02-03-2011 10:01 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now