SQL2008 db table cleanup

I am viewing tables with mylittleadmin tool and would like to know:

1. how to delete mutiple tables at once,
2. how come I am not able to delete the tables with FOREIGN KEY even after deleting the key,

 

...If you remove any relationship you should be able to.
Don't you get an error message showing a dependancy?

 

Thanks Dmitri, I am new to the dotnet world, so please bare with me.
I am/was using "mylittleadmin" tool provided in SQL manager portion of discountasp, to delete the tables.
I have Visual studio 2010 and IIS 7 loaded in my computer.
I was wondering if "management studio" is part of VS 2010 or is it stand alone software? where/how can I get it?

 

...That's used if you have a local SQL Server installed.

You can use mylittleadmin to run SQL and display relationships.
Take a look at this blog post and the comments, should help:
http://blog.sqlauthority.com/2006/1...of-the-constraint-for-each-table-in-database/

 

Thanks again Domitiri, I have SQL SERVER 2008 installed in my computer and I launched Management Studio to follow your instructions. It took few moments to set the settings for first time use and then it poped a window to connect to server, and i don't know how to connect to my db hosted by discountasp.net... it is asking for server type with 4 choices, server name etc.... please walk me through to connect.

 

All that information is in Control Panel, in the MS SQL Database Manager.

 

Well, there are drop down menus and I can not type in the iformation provided by discountasp.net.... still waiting for help

 

...In this Webcast one of the things I show how to do is enter your DASP info into your local SQL Server to connect:
http://www.dasptv.com/avc-view.aspx?videoid=17&categoryid=1

Let me know if you need more help.

 

Thanks this was quite informative. I was wondering if you needed to use sql server 2008 express in between, or youcould directly transfer from sql server 2008 directly to remote site?

 

...You can transfer tables and records but you may loose relationships with the Wizards at times.
The best tool is the attach feature in your control panel but be aware it will wipe your current DB clean.
The next best thing is probably to create scripts then execute them in a SQL window while connected in SQL Server to your remote DB, or use the mylittleadmin, which also allows SQL scripts.
The data pump wizard in SQL Server works in the Express versions now, it didn't in previous versions.

 

Hey wise-mx Thanks for the information again. Do you know that I got into trouble playing/deleting foreign keys and tables.... I need your help in this thread also. http://community.discountasp.net/showthread.php?t=11669

 

Dmitri,
Thanks for your continued help.

A) The reason I am deleting tables is because I had installed and using Gallery Server Pro (GSP) before DNN and resetting the DB to its default state will wipe out all tables which GSP had created and contains users information.

B) I did not know about backing up and resetting the DB till I had both successfully installed GSP and unsuccessfully installed DNN... If I would have known this before attemting to install DNN, I would have backed up and do as you instructed me to.

C) I wish there were someway of telling which tables are for which application. Right now I am distinushing the tables of different applications by the date installed.

D) Would you please kindly help me to resolve this issue: http://community.discountasp.net/showthread.php?t=11669
Thx.

 

Dmitri Thanks for the info. I am going to delete and reinstall both applications. In doing so I would appreciate your resonse to following questions:

1. I had few unsuccessful attempted to install DNN... in most cases the Auto (legacy) button was disabled and I was choosing to install at next page of installation of DNN. And in next page I was given the option to add a prefix for table objects and as you were explaining I was adding DNN in front of the table names.... in my only successfull installation of DNN I was given the option to Auto install (legacy) and when Iclicked on it I did not have the option to prefix of DNN to DNN table names.... My question is that when installing DNN should I avoid Auto installation so I have option of adding DNN to DNN tables?

2. Gallery server pro application, and I think most other applications don't give an option to add special designator to distinguish that tables of application from the others... My question is that if I rename the tables of application with a prefix does it effect the keys and references of other tables to the re-named table?

3. When installing multiple applications, each application has a web.config file. My question is that, can I have multiple web.config in one site or should I comine them and leave one web.config in root directory?

 

Thanks.

1. I don't see any web.config in root directory, only web.configs that come with each application in subdirectories. are there hidden files in sever file system?
2. I am not clear what do you mean by installation files and installation directories? Are you referring to files come under subdirectory when using web application gallery to install applications?
3. how can I designate a specific prefix to tables name of each application... DNN only allows when installing non-auto version (legacy) and most other application don't give you this option... can I rename the tables after installation? if yes, what happens to references and keys of other tables to the renamed table?