[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 830
  • Last Modified:

overwritten the syssegments view

i have overwritten the syssegments view. is this good or bad? can i just replace it with the same view from the master database?
0
stephen_rota
Asked:
stephen_rota
  • 4
1 Solution
 
aprestoCommented:
Hi stephen_rota,

Thats not good, you shouldnt overwrite ANY of the system objects

Apresto
0
 
aprestoCommented:
I misunderstood, thought you said you overwrote the one in master db - you can copy the master one over the top, should be identical
0
 
aprestoCommented:
...but anyway why would you want to overwrite the syssegments view?
0
 
stephen_rotaAuthor Commented:
i did that by mistake i though i was changing another view, i noted the strage union etc in the view but continued anyway. the strange thing is that i tryed to change it again but it did not let me. i will copy the one from master then 10x.
0
 
aprestoCommented:
try to edit if from query analyser:

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

ALTER  VIEW syssegments (segment, name, status) AS
      SELECT  0, 'system'     , 0  UNION
      SELECT      1, 'default'    , 1  UNION
      SELECT      2, 'logsegment' , 0

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now