thulani.moyana (11/3/2008)
But which server role can script the database? Especially when it is on remote server. I'm using SMO and VB.net
The notion of the server being "remote" is meaningless here. You must have a Login at the server, "remote" or not. That login at the remote server, must be mapped to the database and must have sufficient access to the database to be able to script it.
Usually, you just give db_owner to the scripter, however, you should be able to get away with as little as the "VIEW DEFINITION" permission on the database.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]