You must define the primary Publishers and Subscribers, i means, the other server must connected to that server for get a new changes in database, in this way you can...

this from BOL :

awe enabled Option

In Microsoft® SQL Server™ 2000, you can use the Microsoft Windows® 2000 Address Windowing Extensions (AWE) API to support up to a maximum of 64...

Try to make a DTS, and then the stored procedure run that DTS.

Why you used Stored Procedure? I think that it's not the good solution, because you must write a lot of code, even sp can do that.

Replication its a good solution...

try this one, but your query should be work.

select * into Table2 From Table1

It's depend on your application. If your application integrated with other system, like ERP application, CRM, mail, etc, i suggested to use Domain account for starting up the SQL services....

SQL Server cannot execute the statement like that (create or replace), that's why i suggest to create 2 statement.

If you want to simplefied that, trying to use stored procedure.

It is possible, but it will take a lot of resources, because 1 table can have 3 trigger. You must think if the user access the same table in the...

Right, but that will result all movie, not just only movie with new 2 comment.

Try this

SELECT

getdate() as CurrentDateTime,

substring(convert(varchar(100),getdate(),120),9,2)+'/'+

substring(convert(varchar(100),getdate(),120),6,2)+'/'+

left(convert(varchar(100),getdate(),120),4) as CurrentDate,

substring(convert(varchar(100),getdate(),120),12,2)+':'+

substring(convert(varchar(100),getdate(),120),15,2)+':'+

right(convert(varchar(100),getdate(),120),2) as CurrentTime

You cannot display the movie only with timestamp only, because it will result all movie. I think you must define the time when the movie being display for last time,...

You must create 2 statement for insert and update (if you're in query analyzer).

this for insert and the Table have a sam structure :

insert into table a (select * from...

Have you implemented the Log Shipping?

That file most likelly generated from the Log Shipping process

If you still have MDF file you just need to attach the database, the LDF file will created automatically

Your right, OS account related to the service account, for example if you want to sql can connect to the share folder in the network, you must grant non local...