That do in account must exist on the subscriber and have sufficient permissions in the database that you are replicating to

use patindex to find the location of your delimiters and use those loactions for start and end in substring.

+1

What user is it trying to connect as and does it exist on the subscriber?

Is this the snapshot agent or the distributor agent?

So are you finding that the index is used or not?

If it is being used, then you may not want to drop it.

However, if it is not being used, then...

It is best practice that you use AD accounts specifically created as service accounts for the SQL server services.

Then grant these accounts the minimum rights on the box to run...

Furthermore, if you use SQL Server native backup compression, it may be substantially smaller

Since transaction_id is unique, it looks like the second index may be extraneous, unless it is used for covered queries.

Have you checked if it is being used? Google 'SQL Server...

What are the errors in the distributor Agent SQL Agent job?

What type of replication is this?

Transactional or merge?

Job history settings limit total rows in sysjobhistory and number of rows for any given job.

If you have an old backup of msdb, you could restore it with a different...

Gary Varga (10/31/2014)

---

Please don't turn this into a "PRC are attacking us" thread. There are plenty of governments, mine included (UK), which are performing various nefarious activities online. I am...

Just run something like this:

USE [master]

GO

ALTER DATABASE [foo] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

GO

RESTORE DATABASE [foo] .....

GO

USE [master]

GO

ALTER DATABASE [foo] SET MULTI_USER WITH ROLLBACK IMMEDIATE

GO

Don't think they are just rumors....;-)

Occasionally I expose the 1433 port on a SQL server instance to the outside world for testing purposes.

Every time within ~12 minutes I see failed sa login attempts and buffer...