If you don't backup the Log File, change the database recovery option to simple, but first time, detach you database and then attach the database with out the log file...

Dear Raj,

I ever have a problem in the replication like your, about 3 years ago, so I try to share with you to solve that.

Btw, for the DRP, have...

If you run the DTS, it's always depend on your network bandwidth, for your case i think it's good if you use a FTP. You can create a DTS to...

I think you must modify index in the table, try to make unique or primary key, because the lock process only will lock 1 record. If you don't define index...

Only one column can inserting to the variable.

TSQL = SELECT @nBudgetUnit = (SELECT a.MEM_ID FROM dbBudget.UNIT_TREE as a (NOLOCK)

INNER JOIN dbBudget.UNIT as b on...

Change the sa cannot change any object in your SQL, but if you have an application that connect to the SQL using the sa user id, you must change in...

please see :

http://www.sqlservercentral.com/columnists/RDyess/managingjobsusingtsql.asp

As I know, this error display because we not yet update SQL with SP3 or SP4. The installation will be continued.

Finnaly, you can solved it...

Please refer to MSDN, or here the simple VB script to connect to databse :

set cn = CreateObject("ADODB.Connection")

cn.Open "Provider = SQLOLEDB.1;Data Source = SERVERNAME;Initial Catalog=DATABASENAME;User Id=UserName;Password=Password"

SQL Server didn't have synonym object like in oracle.

In SQL it's possible, you just create a linked server to the destination server

Now you add the user id (distributor_admin) to the remote server as a remote login

I think the 'local' option in the sp_addserver must be specified, because you configure the replication in the local machine, right?

Dear Raj,

I'm sure that is because the servername, please refer to the BOL in the section sp_addserver