What procedure do u execute when this error occurs, can u please provide some more information?

Cheers,

Satnam

Why not use the IF EXISTS

Satnam

By replication scripts, it means that it is the backup of your replication.

Thanks for that.

Ideally the replication information is stored in the distribution database ie information regarding publishers, subscribers and so on. Therefore restoring the publisher database again will not be able...

Has the database backup which u r talking to restore been taken after the replication is set?

Satnam

First of all let me tell u that u need to connect to SQL Server Management Studio using sa login credentials to accomplish this task.

Now consider an example wherein u...

On the subscriber,Just check whether the login through which you are trying to connect to SQL Server Management Studio has access to the database.

Satnam

If u are talking about tracking DML changes been made on the table then i would do the following:

I would have introduced columns named created_date, modified_date in the table. First...

Can u please let me know which method are u using to import the file into database.

Also what type of rights does the user have on the system as well...

In order to be a good DBA practice the following:

1. Practice T-SQL. A good DBA is the one whose T-SQL knowledge is good.

2. Read Books Online.

3. Read the articles on...

Books Online will be the best to answer this question.

Satnam

I believe that you can use the OPENROWSET function to accomplish this task.

Satnam

Gangadhar,

Whenever you design a table always keep two columns named created_date and modified_date. Whenever a record is inserted into a table then created_date and modified_date will be getdate(). However when...

James,

Sometimes the subscribers goes out of sync due to which we have to re-initialize it. In most cases due to some issues with the n/w it takes a long time...

Whenever u save the DTS package as SQL Server a job gets created automatically for it. Once that job gets created then u can schedule it as per your convenience.To...