Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kneel
Starting Member
36 Posts |
 Posted - 2009-04-09 : 03:02:50
|
| Hello,I m facing one problem. Somehow some of the tables from my database is moved to System tables folder in SQL server 2005. How can I bring them back under folder Tables?All tables are owned by dbo. Does anybody know the solution for this.Thanks in advance--kneel |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-04-09 : 03:39:53
|
| I guess some body has played around with sp_MS_Marksystemobject in your database.It is an undocumented sp, so I'm also not aware of everything about it.Do a google for sp_MS_Marksystemobject, atleast you will get some starting point.Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
 |
|
|
kneel
Starting Member
36 Posts |
Posted - 2009-04-09 : 06:07:40
|
| Hello,How can I undo this effect? Or I need to drop that object.Thanks in advance--kneel |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-04-09 : 07:16:02
|
| Reading is fundamental[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
jeffnem
Starting Member
1 Post |
Posted - 2009-04-24 : 11:46:20
|
| Some help you guys are. The reason he posted this is probably because he couldn't find it out there. I'm looking for something similar with views. sp_MS_Marksystemobject sets the object as a system object. Do you know how to undo that in SQL Server 2005? If not, please don't patronize by sending me a "go see google" link. |
|
|
|
|
|
|
bring tables back to Tables folder