Do you have to purchase additional license for another instance?

Adam:

You are right. SQL 2005 express edition does not support the Notification Services and SQL Server Agent Services.

However, when I use SQL 2005 express edition to register other standard...

I installed SQL 2005 express edition on Windows XP. But I cannot see SQL Server Agent on it.

I cannot see the Notification Services and SQL Server Agent on other...

In my personal point of view, it is possible that a data import works fine and replication may not. Data Import can be constrained to data only. But a replication,...

MarkusB:

This is a discussion forum. I wish you would not write in that way. We came across this problems before. Here is a link for your reference. Please check.

"You cannot...

Hank:

How abou these links?

http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000--Part-1/

http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/

How about this one?

http://www.mssqlcity.com/Articles/Compare/sql_server_vs_sybase.htm

I believe I am going to fail. Now, try to be a pseudo expert and answer 3 questions.

2. You can always find the rowcount from sysindexes in each database, regardless...

You may "pretend" to Import/Export data. At a point, Save, Schedule, and Replicate Window, check Save DTS Package , then, Structured Storaged File.

Is it what you want?

Agree with Steve.

SELECT * FROM TABALEA UNION SELECT TOP 1 * FROM TABLEB

Does it work?

Type in

replication, sql server

in Google, you will get tons of them.

I believe that you have to set them the same. Snapshot is nothing but a copy.

I do not think you can because each object has its full name including its ownership.

You cannot. You can only restore a database to an SQL Server with later service pack.

You do not have to restore user databases.