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...

Yes, we will change IP too.

My questions is about after rename computer what will show on the scale-out deployment screen, will that show both server names. or only name...

But sometimes those databases need to work with different SQL server versions.

For example some retired db is at version 2000 and only works with 2000, some with 2005 etc.

So only...

Thanks, Jeff.

These databases no longer has front end, their new versions are already upgraded to something new and have diffrent database names.

These are only kept for data...

Thanks Mike for the confirm of the result.

I can choose device files to restore from too, that is no problem.

But when restore a database from another database, SQL 2012 is...

I also tried your way.

That is click databases, - restore database, I specify both the source databse and destination databse,

the list of backup file is shown, then I chose...

In SQL 2008 SSMS, when I want to restore a database from another database, or a file from a device,

I click the database that I want to restore, then click...

Thanks all, this helps me a lot.

Is CodeSmith one of them?

Thanks

Thanks, what are the tools, can you tell me a couple of them?

Thanks

I returned to this, since I think I am not very clear about below and want to verify.

Many posts above mentioned to grant execute to stored procedures, but did not...

So it looks like for in house developed application and databases, all read and write to database should go through by using stored procedure instead of granting db reader and...

Thanks, realized it when I tried to do.

Another question, if we don't need the feature of the service pack, is it necessary to do service pack?

I found in all...

Here is what we found:

Found out if it runs on the server itself, it will run.

Not run from client to SQL Server then to share. It losts the credential and...