Thanks, that is one option I thought too.

But Since our database has online transactions daily, I prefer not giving additional people to query our database directly.

They may have complicated queries...

Thanks, I know log shipping is another way to replicate database, but not sure if it is the best for our situation.

We don't need high availability, overnight is fine.

By using...

Thanks it looks like backup and restore is the better option for us now.

Since the database size is not big and it is a simpler process.

It should only run less...

Thanks all.

The reason is the original code using that column will convert that column to int.

We are writing completely new application to replace the old code.

But for now the quick...

Thank you, is the following statement correct?

1. if we download the version of VS 2012 SSDT-BI, it will separately install a VS 2012 shell for BI template.

Is there going to...

Thank you.

But our database is SQL server 2012 and developers are using Visual studio 2013 for .net development.

Which version of SSDT-BI tools we can download below without asking developers to...

Thanks, I tried to reproduce this, I am in the windows dba group, I add the group to the database. No my specific single user account. and I did not...

You are right.

The single user login co-exists with the windows group login.

It looks that makes the difference.

They co-exist is because sometimes that specific user does need some more priviliges...

Thank you Koen and Jeff.

I ended up to add them as dbreader, db_writer and ddladmin and grant execute to the database.

It sounds a good idea to make a db_executor role,...

No, they donot need to.

They just need to create tables, views, procedures.

and Import/export tables.

Thanks,

Just list of the above.

For that, don't I need to create the users in the database?

Thanks,

I listed what they need in my post.

I was trying to ask advice what is the best way of doing and tracking the permissions.

Thanks,

I agree DB owner is some risky, so what role or permission should I grant them as mentioned in my previous post?

And how to easily track them later?

Thanks

They told me they would like full control of the database.

And I know what they need to do is to create objects in the database, import/export data, query database.

To grant...

More info about my question:

It is easy to rename SQL server with only DB engine and/or SSIS installed, for reporting server it is a little tricky.

Especially on the Scale-out deployment...