Have a look at this article[/url]. It should help.

John

I can't see any value in backing up a database that is a copy of another database that's already being backed up.

Also, are your backup files really on the same...

That's all a bit vague, although if I had to guess I'd say that you're missing some parentheses around your AND and OR conditions. ANDs are evaluated before ORs...

A UNC path starts with a double backslash.

John

H:\ isn't a network share - it's a mapped drive. Drives that you have mapped are visible only to you, not to the SQL Server service account. Try...

What do you get if you run this?EXEC xp_cmdshell 'dir C:\Users\moody\Desktop\api.json'John

You've lost me, I'm afraid. Please will you post the whole statement and the whole error message?

Thanks

John

Here's one way of doing it:WITH SecurityExamples (Line, Value) AS (

SELECT 1, 'G H2' UNION ALL

SELECT 2, 'G-M3' UNION ALL

SELECT 3, 'G U4' UNION ALL

SELECT 4, 'G-X2' UNION ALL

SELECT 5,...

Something like this:

IF EXISTS (

SELECT ID

FROM Inserted i

JOIN Deleted d ON D.ID = I.ID AND D.Department <> I.Department

)

BEGIN

<Your INSERT statement here>

EXEC sp_send_dbmail <mail parameters here>

END

John

Use the Inserted virtual table to compare the value of Department before and after, and only insert those rows where it differs.

John

Yes. See you there!

John

Or create a unique filtered index to avoid the need for a trigger:CREATE UNIQUE INDEX UQ_CustomStudent_personID_value_attributeID

ON dbo.CustomStudent (personID,value,attributeID)

WHERE value = '17'

AND attributeID = '9875'

John

You haven't given any examples of exactly what you're trying to prevent, but from your description, it sounds as if you could do all this (except the e-mail) with CHECK...

The...

Yes, that's broadly what I had in mind. The reason I thought it more complicated is that my definition of median includes taking the average of the two middle...