Solved

overwritten the syssegments view

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

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 …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

810 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