Thanks Again. But, if that account is a "SA" & not a windows trusted connection how will I assign the SQL Server login id with network rights on them.

If I'm...

Thanks, Jack. But, how to find the service account name that is running the SQL Server instance?

No. Its a single script, a single click at the front end would trigger a script to create database & all objects.

It has around 2000 objects table, indexes, functions, stored...

Hi Mahesh, Bob,

First, I appreciate replying to this post. The reason for different databases are:

1. This is a product which an organization who decide to use will select a database...