Admin MSDE used by web site 1

[SpiderBear6]

I have a web site that uses an MSDE database. How do you administer the database (ie, if you have to change a table structure). When I try it says I don't have exclusive access which is probably true. I did try stopping the web site application but that doesn't seem to release the MSDE database. I'm not sure whether this should go in the IIS forum or this one. If someone could point me in the right direction, I would be grateful.

Cheers.

--------------------------------------
"We are star-stuff. We are the universe made manifest trying to figure itself out."
-- Delenn in Babylon 5 - "A Distant Star"

 

[mrdenny]

Spider, what the exact error message that your getting back? Doesn't sound like a message from the SQL Server. Are you using some sort of web based tool to manage the database?

Normally I would use Enterprise Manager if available. If not then use osql to execute the alter table statement(s).

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.

 

[SpiderBear6]

Because I am using MSDE.. I was hooking into the database using Access 2000. Probably not a good idea..

--------------------------------------
"We are star-stuff. We are the universe made manifest trying to figure itself out."
-- Delenn in Babylon 5 - "A Distant Star"

 

[mrdenny]

Your not going to be able to make changes to the table from Access.

There is an ASP.Net version on Enterprise Manager available from

http://sourceforge.net/projects/asp-ent-man/.

This allows you to do table changes. Or check the Books Online for the Alter Table Syntax, and run those scripts via osql or isql.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.

 

[SpiderBear6]

Thanks Denny... I might take to osql approach. One question though .. when you run an alter table statement from osql, does it handle the fact that the db is in use?

--------------------------------------
"We are star-stuff. We are the universe made manifest trying to figure itself out."
-- Delenn in Babylon 5 - "A Distant Star"

 

[mrdenny]

Yes it does. The change will not be commited until there are no active transactions. Once the change is made, any pending transactions will be processed.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.

 

[SpiderBear6]

Great... thanks Denny.

--------------------------------------
"We are star-stuff. We are the universe made manifest trying to figure itself out."
-- Delenn in Babylon 5 - "A Distant Star"