Solved

overwritten the syssegments view

Posted on 2006-07-24
5
780 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

685 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