Modify System Tables?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Morey - 14 Mar 2008 14:57 GMT

Hi --

I am working on a project on top of SQL Server 2005 and I would like to
store some additional information relating to the tables and fields in my
data base. Is it acceptable to alter the system tables to add my own fields?

Thanks

Rich

Reply to this Message

Russell Fields - 14 Mar 2008 15:18 GMT

Rich,

No it is not. I don't think it is possible any more and it will certainly
break things if it is possible. Much, much better to create your own
parallel tables to hold other information, if you need to do that.

But first, look into using Extended Properties.
http://www.developer.com/db/article.php/3677766
http://www.devx.com/dbzone/Article/27793
http://technet.microsoft.com/en-us/library/ms190243.aspx

RLF

> Hi --
>
[quoted text clipped - 6 lines]
>
> Rich

Reply to this Message

Richard Morey - 14 Mar 2008 21:32 GMT

Hi --

Thanks for this tip. I will definitly take a look.

Rich

> Rich,
>
[quoted text clipped - 19 lines]
>>
>> Rich

Reply to this Message