Good article. Mind Mapping is very useful.

However I think you missed out one of the main functions of mind-mapping - for Studying, especially for long term understanding and data...

This is very good Paul.

Concise and Clear, not too long and with easily understandable examples.

Thanks for taking the time to create this article. I appreciate your efforts.

10...

Loads of possibilities. Its just a matter of tracking down the right one.

You could try copying all the smo dlls in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies to your web project...

Yes just created the user without db_owner under Schemas Owned by User

I am curious. You use 'Dev' as a nickname. Would you describe yourself as a Developer...

Well after looking through ALTER USER, DROP SCHEMA, ALTER DATABASE - I couldn't find any way to do this.

So I've just dropped the database and re-created it, with the user...

No, the user is 'TestUser'

User's Default Schema is 'dbo'

And user has db_owner under Schemas Owned by User

and user is in db_owner under Database Role membership

I just want to remove db_owner...

If I understand you right, the server already has SMO v 10.1 - This is still the non R2 version, so there should be no problem installing that same version...

Nice question Tom.

Probably not the best starting point if you're new to this....

there are plenty of articles on how to split comma separated strings on this site.

for (2) you can pass DBName as a parameter and use dynamic SQL

DECLARE @DBNAME sysname;

SET @DBNAME...

What is the error when you try create table in ssms?

*** IMPORTANT ***

Make a restore point on the server before installing anything.

Jako de Wet (11/29/2011)

SMO is not installed on the server, the version on my dev PC is

MS SQL Server 2008 Management Objects

Version 10.0.1600.22

Can I install this to make it work?

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16978

2008...

Try Control Panel Add/Remove programs (XP) or Programs and Features (Win 7)

You will have an entry

Microsoft SQL Server 2008 Management Objects

version 10.0.x.x

~OR

Microsoft SQL Server 2008...

Check if Sql Server Management Objects (SMO) is installed on the server.

If it isn't be very careful to install the same version you developed with.

I've had issues with SMO versions...