You can create SSIS packages on Main office server or create linked server ...

Replication is one option ...but I think Express Edtn will not support replication...

If you are doing merge replication then it will add guid column but not in transactional replication...

I think you can do bi-directional transactional replication too...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergperf.mspx

http://www.databasejournal.com/features/mssql/article.php/1438231

http://support.microsoft.com/kb/820675

http://msdn2.microsoft.com/en-us/library/ms151855.aspx

Are you talking about the ITW option in Query Analyser in Query tab?

You should have some query in your QA otherwise it will be greyed out (disabled)...

Try specifying network protocols while connecting...

To connect using named pipes you have to "np:" for tcp/ip you should  "tcp:"

In Client Networ Utility check enabled protocols and try changing the protocol...

I don't think you can prevent some one using the QA but if they are using any perticular login you can deny that login...

Application roles may help you in this...

I don't agree with you...

Single user mode always works as long as you follow the directions...

I have done backup/restore many times using GUI and never had any problems...

Best place to find realtime issues/solutions will be sql forums....

Read the forums as much as you can...

http://www.databasejournal.com/features/mssql/article.php/1547551

http://www.databasejournal.com/features/mssql/article.php/1468971

Does SQL server service account has the access to the other system where you trying to run the batch file using psexec?

You make use of the following scripts with SP_MSFOREACHTABLE procedure to do it all at once....

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1541

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1526

Try to delete after disabling the FK...

CREATE TABLE cnst_example

(id INT NOT NULL,

    name VARCHAR(10) NOT NULL,

    salary MONEY NOT NULL

    CONSTRAINT salary_cap CHECK (salary < 100000)

)

-- Valid inserts

INSERT INTO...

From MSDN thread..

What I have done is that When this window Authentication Mode appears i starts the sql server 2005 service.Then clcik the next button.That's all we have to do.

I have...

Some other connection might has got the connection to that database...

Try in Query window (Query Analyzer).. before doing put the db in multi user mode...

Ex:

1. ALTER DATABASE Northwind SET SINGLE_USER...

Your coulumn name might have special characters or spaces in it...

You can log errors to an output to get more details about this error.

How to enable replication agents...

Is parallalism enabled? If it is try the same after disabling the parallalism using MAXDOP option..

You may need to call PSS...

Are any stack dump files in sql error logs?

I didn't get your question...

What OSQL script is going to do??

Is it creating the db or something else...

You can create a batch file using osql script and call the...