If you have SQL Mail configured, you can create a job that post the mail to your adress and attach the .bak file. Use xp_sendmail @recipients = 'email adress',

@attachments =...

The best way is always with T-SQL. Check BOL for sp_attach_db and sp_detach_db. To detach the db use sp_detach_db Dbname, then move the data files or what ever you want,...

I read once that if you change for example a column from nullable to non nullable, what EM does, is create a temp table with all the data before changes,...

Try changing for testing the login mode To Mixed Mode (SQL and Win) and with Query analizer, log with any SQL login (sa).

If you are still with problems, maybe you...

I already fixed it. I decrease to one the ReadBatchSize parameter of the log reader agent profile. Left the log reader reading all night from the log all the transactions...

Yes, consider it as another instance of SQL Server 7. You can Register it into EM and use it just as another server. The name of the instance is the...

What I would do i save the highest number in a variable like this:

DECLARE @Nro AS INT

SELECT @Nro = TOP 1 SeqNum FROM Table Order BY SeqNum DESC

And then insert...

What I did once was to restore the master database with a different name, and then from the old sysxlogins inserted into the new one all the logins that I...

If you are replicating bettween differents servers on your network, you must use a Domain Account for you SQL Agent service account. Otherwise, you won't be able to replicate.

Use local...

Already did, like I posted before.

Check the query time out in your query analyzer in tools, options, connetions tab.

Run sp_who2 and check if there's a spid with backup commands and check if it is locked. If so, check the job, because to backups may be running at the...

And with a domain account you can use SQL Mail, and also replication.

Why do you need no connections during the database copy? You could kill the sessions what that would force a rollback in the user transaction

With bcp you can export to a text file not to excel. You must execute BCP -q"Select of columns that you want" textfile_path -Usa -Ppass -dDatabase. Check also running bcp...