A trigger has many of the same rules as stored procedures. The main exception is you can't execute a trigger; it fires based on the parameters of the trigger (for...

Not unless someone dropped it (and in those cases it was unintentional such as they were in Enterprise Manager and accidentally deleted a column).

It looks like it's generating a scalar to serve as a row check for the INSERT into TempDB. If you follow the output of each step, you'll see that generates...

You're going to probably want to look at Full-Text searches against the name and description fields (you'll have to set that up and schedule the updates). That will speed up...

Jack Corbett (11/16/2007)

---

While I agree with this point, I think the point of the editorial is that technology has made it easier to steal data. I can get 1000's...

There's quite a bit of information about schemas in the SQL Server 2005 Books Online (documentation that comes with SQL Server). If, however, you're familiar with the concept of namespaces,...

majorbloodnock (11/16/2007)

---

@Brian, I hold by my original statement. This isn't a technological problem; it's only the solution's implementation that's technologically based. What you're trying to achieve is as old as...

jayanth j kurup (11/16/2007)

---

We have something similar implemented where the database integrity is not being maintained by relationships between tables , instead they have decided to use triggers to try...

majorbloodnock (11/16/2007)

---

Once again, I think this is an example of looking at the technology involved in a problem and then assuming it's a technological problem overall. I don't believe this...

Jurriaan Themmen (11/16/2007)

---

1) "Lost or stolen device". Can't the industry come up with some kind of key-pair solution for this, like they have / had in PGP ? The idea...

USB and portable devices can often be encrypted. The major HDD encryption vendors out there... Safeboot, Utimaco, PointSec, etc., all have products that do so automatically when inserted. However, they...

You can run the Microsoft SQL Server 2005 Upgrade Advisor to see what issues, if any, are present in the databases to migrate. This will tell you if leaving the...

MP (11/15/2007)

---

I ran a test and backed up the database and restored it onto another server and I was able to access the encrypted columns without any issues. The...

I'm reading in a few other places that you need to set your database compatibility mode to 90 (SQL Server 2005). Is this possible?

No. I hadn't had time to experiment to see what exactly is needed for this.