can you ping the server?

can you establish a telnet session to the server ip on the sql port?

Dave - I get it now!

Couldn't see the wood for the trees, and thought it was a simple 'HAVING' answer!!

some sample data.....

declare @tblClient table (Clientid int, clientName varchar(10))

insert into @tblClient

...

Not directly - no you cannot use wildcards.

You can however pass a variable in to the xp_sendmail proc, so simply determine the filename, store it into a variable @filename

and...

Dave Ballantyne (8/18/2009)

---

SELECT COUNT(dbo.tblBackup.BackupID) AS Total, dbo.tblClient.ClientName

FROM dbo.tblClient INNER JOIN

dbo.tblBackup ON dbo.tblClient.ClientID = dbo.tblBackup.ClientID

WHERE (dbo.tblBackup.BackupDate BETWEEN '2009-08-17 19:00:00' AND '2009-08-18 09:50:00')

Having COUNT(dbo.tblBackup.BackupID) =0

However that will still not work ,...

Youve got a mixture of SQL authentication and Trusted connection in there. Not sure if that is your issue, but try changing the connection string to

"Integrated Security=SSPI;Persist Security Info=False;Network...

OK then

SELECT

tlkp_Defects.Defect_Title,

count(*)

FROM

tbl_Assembly_Hold_Defects

join tlkp_Defects on tbl_Assembly_Hold_Defects.Defect_ID = tlkp_Defects.Defect_ID

join tbl_Assembly_Holds on tbl_Assembly_Holds.TagNumber = tbl_Assembly_Hold_Defects.TagNumber

WHERE

tbl_Assembly_Holds.Record_Date...

I've just noticed I missed a comma out so try this

SELECT

count(Defect_Title),

tbl_Assembly_Holds.Record_Date

FROM

tbl_Assembly_Hold_Defects

join tlkp_Defects on tbl_Assembly_Hold_Defects.Defect_ID = tlkp_Defects.Defect_ID

...

I think I understand your requirements, try this..

SELECT

count(tlkp_Defects.Defect_Title)

tbl_Assembly_Holds.Record_Date

FROM

tbl_Assembly_Hold_Defects

join tlkp_Defects on tbl_Assembly_Hold_Defects.Defect_ID = tlkp_Defects.Defect_ID

join tbl_Assembly_Holds...

Another way is to add '-' (hyphens) , which turns the date into a USA format date (style 10)

'081709' becomes '08-17-09'

then convert that to a varchar using ISO datetime format...

makes no difference to the answer, but the question states that the backup location is 'F:\......', but al the answers refer to a location at 'C:\......'

probably just a typo

Kev

What is the reason for not copying the backup file?

The data will have to traverse the network anyway.

Can you access the first server from the second, i.e. via a mapped/net...

ChandraMohan Nandula (7/15/2009)

---

Count is an aggreate function which accepts only one input parameter. In your query you are trying to input two columns as...

You didn't state which version, but when I started, I found this book a great help Microsoft SQL Server 2005 Reporting Services Step by Step (Microsoft Press)

Kev

An update.

The item on Connect isn't exactly the same thing, but it's asking for the kind of functionality I was looking for - i.e. being able to manage the connections...

Similar item on Connect, https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=424800

Kev