Convert System tables to User table in SQL 2000

Hi
I have some tables created as system tables by mistake. How do I
convert them back to user tables.
Thanks
HP
I'm not too sure how you could have done this 'by mistake', but please take
a look at this http://www.transactsql.com/html/sp_M...temobject.html
to switch objects back.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Paul Ibison wrote:
> I'm not too sure how you could have done this 'by mistake', but please take
> a look at this http://www.transactsql.com/html/sp_M...temobject.html
> to switch objects back.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
It is test server and somebody has messed up something that was causing
all object created as system object. I ran the script this morning to
switch but tables are created in last 2 days with this config are still
showing as system tables.
Thanks
Hp
|||HP wrote:
> Paul Ibison wrote:
>
> It is test server and somebody has messed up something that was causing
> all object created as system object. I ran the script this morning to
> switch but tables are created in last 2 days with this config are still
> showing as system tables.
> Thanks
> Hp
Hi Paul,
I looked the link you suggested. I want to do opposite to that script
Thanks
Hp
|||Have a look at the text in the procedure: sp_helptext
'sp_MS_marksystemobject'.
You'll need to do the reverse to unflag the tables. You might want to have a
PSS engineer work through this with you as it's a pretty unsupported method.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Convert System tables to User table in SQL 2000

Hi
I have some tables created as system tables by mistake. How do I
convert them back to user tables.
Thanks
HPI'm not too sure how you could have done this 'by mistake', but please take
a look at this http://www.transactsql.com/html/sp_...stemobject.html
to switch objects back.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Paul Ibison wrote:
> I'm not too sure how you could have done this 'by mistake', but please tak
e
> a look at this http://www.transactsql.com/html/sp_...stemobject.html
> to switch objects back.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
It is test server and somebody has messed up something that was causing
all object created as system object. I ran the script this morning to
switch but tables are created in last 2 days with this config are still
showing as system tables.
Thanks
Hp|||HP wrote:
> Paul Ibison wrote:
>
> It is test server and somebody has messed up something that was causing
> all object created as system object. I ran the script this morning to
> switch but tables are created in last 2 days with this config are still
> showing as system tables.
> Thanks
> Hp
Hi Paul,
I looked the link you suggested. I want to do opposite to that script
Thanks
Hp|||Have a look at the text in the procedure: sp_helptext
'sp_MS_marksystemobject'.
You'll need to do the reverse to unflag the tables. You might want to have a
PSS engineer work through this with you as it's a pretty unsupported method.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .