arnipetursson (4/9/2013)

---

Is this the log reader agent or the distributor agent? You mention both.

What happens when the agent job restarts?

Do you have the job set to auto restart...

DECLARE @ID int

SET @ID = 3

SELECT ID + 1 WHERE ID = @ID

?

Place trigger on the msdb..sysjobs table for each server you wish to monitor - something like the code attached will work, just add in the statements to check the INSERTED...

What's the network connection/switches between all this hardware? Is the DB server connected to the SAN via a fiber-channel or regular ethernet? Also does the same performance issues...

Not meaning to hijack the thread (but I have a question that is directly-related). If dealing with 2 logs files (the primary LDF file and an additional) and log...

Also, the date datatype won't work in SQL 2005, it's new to SQL 2008

Something simple?

DECLARE @Tmp TABLE (col1 varchar(8))

INSERT INTO @Tmp

SELECT '201210' UNION ALL

SELECT '201211' UNION ALL

SELECT '201212' UNION ALL

SELECT '201301' UNION ALL

SELECT '201202'

SELECT CONVERT(date, col1 + '01', 101) FROM @Tmp

If you haven't specified it during the initial install, it's set to 0 by default, meaning that it happens automatically (running approximately every 1 minutes for active DB's)

Reference MSDN here

How can I remove my post?

😀

The issue is it can't read the file at D:\unc\DAMIAN-PC$PCTWO_TESTOWA_TEST

This error is "The system cannot find the path specified"

Check that the service account (running your replication agents, etc.) have the necessary permissions to the directory(ies) - currently it can't...

At the SQL Server instance level do you have the publisher and subscriber to "Allow Remote Connections?"

And in your linked server, have you enabled "data access"?

I'm going to assume there's more rows in the table than 2, and you want just the last 2 of them ordered in ascending order?

Try:

;WITH MyData AS (

...

There are many alerts you can set up via the replication monitor (I encourage you to set those up as well). To create a custom process to track (this...

GilaMonster (3/15/2013)

---

Why? TempDB files, like user database files, are used with a proportional fill algorithm, so there's no difference between 2 files of 140GB and 4 files of 70GB, it's...