Lynn Pettis (3/15/2010)

---

Yes, in SQL Server 2008 it is missing the data type. Should be:

DECLARE @selectDate datetime...

John Paul-702936 (3/15/2010)

---

Hi , I have 2 SQL Servers with the Databases ... i want to have a sinfle IP address with refelcts the 2 servers

Can someone please explain...

I recommend the replace option that was provided.

As an option, try the below changes.

;WITH Excpt

as

(

SELECT

A.DetailID,

A.ClaimID,

B.MCareNo

,Row_Number() over (Order by a.detailid) as RowNum

FROM dbo.udf_GetDetailsAsOfTaskListID(17, 0) AS A

LEFT JOIN dbo.udf_GetClaimsAsOfTaskListID(17, 0) AS B

ON A.ClaimID = B.ClaimID

WHERE...

I have seen Veritas report as failed but the job is actually successful. What is the extension of your log backup files (IIRC Veritas likes to use a different...

I would have to still go with SSMS - it comes free with SQL Server.

Yup

There is a nice compilation of samples here:

http://www.connectionstrings.com/sql-server-2005

Backup summary.

Avg Disk Reads / Writes

SCOM could get you some of the info you need. Other options are to use PowerShell, SMO, tsql scripts to build a custom in-house...

Steve and GTR have provided good information.

The log backups are due to either a job or a manual intervention.

You also might want to verify if Log-Shipping is present.

I recommend you follow the steps outlined in the Log Growing pains article here:

http://www.sqlservercentral.com/articles/Log+growth/69476/

This can help you identify the source of the growth and then you can optimize and correct...

What versions of SQL Server? What kind of environment (clustered, replication)?

A little more information might be helpful.

Nice Question Ron.

Paul White (3/15/2010)

---

Actually, I had to think quite hard to get that cursor right. I am not proud of...

Hope you had a good birthday as well.