Post in appropriate forum

There are thee types of 'temp' tables, all stored in the tempDB database.

Global Temp Tables.

Created by CREATE TABLE ##MyTempTable AS ...

They are visible to all sessions. If not explicitly dropped,...

Where is the SQL Server instance located?

Log shipping sends a backup of the log over and restores it. It's only as up-to-date as the most recent log that was shipped over....

if you want to a copy...

You can go for replication

If you plan for transactional replication then all the tables must have primary key.

What you mean a gud proven product and not sql server(third party) tool??

If you using SQL Server 2008 R2 why cant you try data tier application and I think there are some more features in R2 which supports centralised administration.

Am with 456789psw

Thanks Lowell

The application wont connect to database...

For remote connection you should enable both TCP\IP and NAMED PIPES

Try windows performance monitor..u can add counter for each instance..

Have u receiving the same error while clicking any other options in SSMS??

Is that job u created from scratch or migrated from anywhere???

Update in the sense??

If its data and both SQL & MySQL have same structure its easy..Can you please be more specific on your requirement??

Try Login to SQL Server in Single user mode and add a user from new domain.. or enable the sa login

🙂