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

Thanks, the same address could be in the log table twice in case they move out an address then after a year move back. so this is correct case.

we just...

removed