Solved

overwritten the syssegments view

Posted on 2006-07-24
5
756 Views
Last Modified: 2008-02-01
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
Comment
Question by:stephen_rota
  • 4
5 Comments
 
LVL 23

Expert Comment

by:apresto
ID: 17168451
Hi stephen_rota,

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

Apresto
0
 
LVL 23

Expert Comment

by:apresto
ID: 17168463
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
 
LVL 23

Expert Comment

by:apresto
ID: 17168483
...but anyway why would you want to overwrite the syssegments view?
0
 

Author Comment

by:stephen_rota
ID: 17175241
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
 
LVL 23

Accepted Solution

by:
apresto earned 125 total points
ID: 17175251
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL: Nested CASE Statements 4 24
Sql query 107 29
SQL - SP needs a little help 9 22
SSRS Dynamic Column Names - Last 8 Weeks 3 16
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now