Problem 1: Upon starting SQL Server Express I get the following error:
"An unhandled exception has occurred in a component in your application....Cannot create a stable subkey under a volatile parent." Clicking OK lets the Server continue and I can use it quasi-normally.
Problem 2: Also, when I try to generate a diagram, I get a message that states
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
But, the database HAS an owner, and resetting the owner (using the Files...) to other users has no effect.
Problem 3: I tried to change the name of a database, and it refused to do so. Except that now all objects under the database name (it is the same old name) have disappeared. Is there a magic folder somewhere that contains all of the tables, etc. that were 'banished' from the server
Is there a way to detach the databases from Express and reattach them to the SQL Server 2000 I am also running Last time I tried the 'detach' worked but all the objects were wiped out by the 'attach'. Handy feature.
Thanks
Glen
SQL Express errors: Diagram component, startup error
Shobha69358
1. This is a general program error, not specific to Express. I would ensure you have all service packs, both OS and SQL Server, installed.
2. Are you trying to generate a diagram on an SQL Server 2000 server The two are different formats.
3. How did you change it And what do you mean, "it refused"
4. You can attach lower to higher, but not the other way around.
Buck Woody