What about:

INSERT INTO dbo.StandardSubject (AssessmentSubjectID, [Name], Description, AdoptionYear, IsActive, [RowVersion])

SELECT *

FROM (

SELECT AssessmentSubjectID = NULL,

[Name]...

My two cents: I wouldn't install an antivirus on a production server. I would rather perform a remote scan from another machine.

For what I have seen so far, none.

It doesn't look like you have...

So I guess you're not paying mine either.:crying:

Thanks Alvin, it's...

I agree with everything that has been said so far.

You could also set up a logon trigger as Dale Turley suggested, or create a scheduled job that does something like...

I'm sorry, I'm not a unit testing expert. I hope somebody else can give you good advice on the subject.

Well done, nice solution!

My two cents: those who tell you that business logic can completely live...

Try using EXEC([sql]) AT [server]

My sincere apologies to everybody for posting code in The Thread.

It will never happen again.:-D

Yes, but you're not executing the user input. The user will not be able to append a something like ';DROP DATABASE myDB in the input, that will always be treated...

One strange thing is that I keep on being redirected to THE THREAD when I click on the link to the PhD-ese thread, but if I edit the original post...

Grant Fritchey (1/25/2010)

GilaMonster (1/25/2010)

Didn't need to (and I think Grant has the crystal ball...

Did you use your crystal ball, Gail? 🙂

Sorry for the broken link, I'll fix it.