Thanks for the suggestions and the log table gives me some good ideas on what I could use. The application I am working with has almost no user interaction in...

Hi,

Not sure if you solved this problem already but it sounds like what developers call " the dreaded double-hop issue." Here is a link to an MVP who has answered...

Apologize for not responding sooner but I'm looking forward to trying this out in the test table and our production set. Thanks again.

I believe the merit of stored procedure encryption is that it presents a basic layer of "obfuscation" against competitors seeing your business logic.

I can see Jeremy Pischka's original point...

Thanks for taking the time to write up this explanation. I'm going to try the OPTION (RECOMPILE) as you suggested. I think a bigger problem is the requirement to find...

I see. And when I modified the query to include a device_id in the where clause then it used the non-clustered index.

Thanks very much for the explanation.

I actually tested the script out before I submitted it and the backup will happen. I used a corrupted database as the sample.

To GSquared...that makes sense. But what about the 2nd normal form?

"each non-key field is functionally dependent on the entire primary key"

You can't have a driver's license without an employee. But...

To GSquared:

I think it could theoretically happen. The employee could be authorized to drive and then lose that authorization. I don't know if it would make sense to delete the...

In terms of the business rules, there are only employees. Those who are authorized to drive and those who aren't. But that's essentially my question. Should I create a second...

Unfortunately our team doesn't own the structures and the idea was to make as few changes in the non-database side of the software.

Once I saw your code, I finally understood what you meant by temp tables and an index on the XML column. Thanks!

Here is the problem. Once you add all the...

The use of a temp table vs. table variable seems to make no difference.

So here is the code. At least this code will build an XML object that is very...

Laptop specs are as follows:

SQL Server Express SP 3

Dell Latitude E6400

3.5 GB RAM

Core Duo 2.53 Ghz

The xml structure is below:

="xml"

...

Thanks. I tried the nodes method as well but that performance was even worse. I would like to try the nodes method with a schema collection (which I've read can...