Something like this:

CREATE TRIGGER emptrigger ON emp for INSERT

AS

BEGIN

IF NOT exists( SELECT e.empid

FROM emp e

INNER JOIN INSERTED i

ON...

You can't set a constraint between a table and a view, but you could set a trigger that would check to see if the inserted data was in the view.

Perry is correct, but you should be OK in terms of your app with the compat mode. I haven't heard of issues, but I haven't seen many people running in...

Of course the points are inversely proportional to your job. Isn't that how reviews are handled as well? And interviews?

It's actually a fun decision on my part, giving people a...

Nothing in SQL 2005. In 2008 there is the Resource governer, which can help if you setup a separate login for that report.

The Indian copyright law sounds better to me, though not if it requires local software. DRM bypass for personal use, or fair use, I'm OK with.

That's a different story than...

Good to see some people doing this.

I'm torn on the disk space argument. It does cost $$, but so does people's time. If there are other things to do, is...

Here you go: http://www.sqlservercentral.com/scripts/Search/69345/

I'm not sure what you mean, and I'm not sure you know what you need.

Access in SQL Server starts at the server level. So the administrator of the system can...

I'm not sure about the debugging, but the issue is that most of the auditing requires sysadmin permissions, and they can disable auditing as well as enable it.

snow

Coming down again, 2" on the ground and a camping trip tonight.

Good job, everyone on the plagiarizer. I saw the email late last night from Brad as I was watching a movie with my wife and (wisely) declined to open the...

I have plenty of manure around here. And I can tell pretty loud, according to my kids.

I don't think so, but I'll ask around and see. There has to be something that's sticking here. If it's not storage, I'm at a loss.

Hey! someone agrees with me 🙂

Replication can work well for you. Consider that.