Yes. that sp it is only for snapshot or transactional replication.

are you running any other process or job, like backups or creating indexes?

Wich service pack?

MAybe you should try with a select statement with query analizer. If also returns an error you can check the table consistency with dbcc checktable.

you can check http://www.microsoft.com/sql to learn more about the new version call Yukon.

You must login to your windows server, not SQL with the domain account you use to start the services. Then create a mail profile and configure SQL. Always in the...

To configure the email you must use a domain user to start both sql services (mssqlserver and sqlserveragent). Then you must log in to your server with that user, and...

You must have a mail client that can be outlook. But is must configured in sql. It is not just adding your email adress.

You can also be notified by...

EMPTYFILE is when you have multiple datafiles and want for example to delete one, so you use emptyfile and the data of that file is spread between al the other...

Yes I know. It an example to show you that you can use xp_cmdshell

Why don't you sincronize first with the full and then only pass, differencial and logs backups.

Or why don't you configure a real Standby server, to let SQL to pass and...

No, the target server is an entry in the master server. It must be erased from the master.

From the target you can force a poll for example.

you can't do ir directly in the same query.

All the field with no functions must be in the group by. But I guess you could create views, or temp tables...

You must have a Domain user configured to start both SQL Server and SQL Server agent and that user also must have a mail profile in a mail client in...

Do you have SQL mail configured already?

That is how it works. You want see your targets servers databases in the maintenance plan. If you have the same db in the master server, then you can select...