Thanks, I've got the answer already. I had to use isnull() function for this

Thanks a lot guys out there.

I've noticed that the key columns include a sort order eg. asc but the columns in the include clause don't, do I add this sort...

Sorry for not answering straight.

I'm using SMO and vb.net (Even c# can do). I want to loop through the objects of a table then add the column to the other...

Thanx for the response.

Yes, I have an application already but I need to take the exact copy of the column from one database to the other. If I have to...

Thanks a lot.

This makes sense now. I tried to add the "View any definitions" permission to the Login I'm using. I could establish that the Login I'm using cannot add...

Thanks again.

But which server role can script the databse? Especially when it is on remote server. I'm using SMO and VB.net

Thanx for the reply

The Login name is mapped to dbo user wich is has the DB_owner role. Does this role have full acess to the database or I have to...

Thanx once more.

The error I'm getting is:

Script failed for Database 'DatabaseName'.

Maybe this can help:

Message="The server principal "SomeName" is not able to access the database "DatabaseName" under the current security...