Diagram, script and security ...

Three things:

1 - I attached a database from another computer in the Microsoft SQL Server Management Studio Express tool. It looks like my database diagrams did not follow.At first, it told me that the owner of the database was not set correctly and, hence, diagrams could not be supported. I ran the following query to fix that -> Alter authorization on database::DB_NAME to [MACHINE_NAME\USER]. Now, I can create new diagrams but I would like to see the ones I had before. How can I transfer my database files (.mdf and .ldf) with the diagrams?

2 – I would like to generate a database script that would not only create the table structure but also generate the insert statements to populate the database. When I use the “generate scripts” wizard, I don’t see an option where I could get the insert statements included in the script.Any help would be appreciated.

3 - I would like to read/find a short tutorial on how to set up security for my database. For now, I use the default user/security everywhere and I am sure it is not a good way of doing things. Basically, I would like to make sure I am not leaving a big security hole without having to read an entire book on SQL Server.Where could I get started?

Thanks a lot,

Dom.

1/ the diagrams should have come across with the database as they are stored in special tables, was this a SQL 2000 db that was upgraded by any chance?

2/ There is no way to generate insert statements in the UI today, there are some samples out in the community that can do it through.

3/ Have you read books on line?

|||

1 - No this is not a database upgrade, a SQL Server 2005 Express Edition to SQL Server 2005 Express Edition

2 - This is sad, there should be something to generate insert statements.

3 - Do you have any good ones to suggest?

thanks.

|||

Check out Securing your SQL Server Express Edition Server, it's from beta, but all the prinicples apply. You can also read the various pages of the BOL linked to from the Security Consideration for SQL Server topic.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!