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 |
|
hey137
Starting Member
5 Posts |
 Posted - 2007-12-11 : 12:07:25
|
| I made a copy of our database and restored it to a new database. We want to strip all the content out except the users and roles. I have been able to delete everything except "system" tables, views and stored procedures. Can anyone help me get rid of these?Thanks - Kelli |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-12-11 : 12:09:23
|
Kelli -- has it occurred to you that perhaps SQL Server needs those system objects to function? Which is perhaps why they are called "system" objects?  - Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-11 : 12:12:18
|
| sure thing... the best way is simply to use truncate table.jeez..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
hey137
Starting Member
5 Posts |
Posted - 2007-12-11 : 12:43:25
|
| Considering that some of them do not follow the standard naming, I believe they were created specifically for the old database. An example of one I want to remove within the Stored Procedures is dt_addsourcecontrol. I checked in both the master, model and Northwind, none of these databases have any "dt_" procedures. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-11 : 23:25:48
|
| Sql created those tables when you generate diagram or so. Leave them. |
|
|
|
hey137
Starting Member
5 Posts |
Posted - 2007-12-12 : 08:42:17
|
| got it ... thank you! |
|
|
|
|
|
|
Remove System Tables