One advantage of another table is you get some "history" as well. You can see who changed it when. If you do this, you might also think about periodically archiving...

Crazy.

After you test, what I'd also do is remove the user explicitly and make sure they're not in any other groups from Windows. Then let them connect through the group...

I am confused. I would follow Brian's suggestion and trace the excel and Access connections, trying to select from the same object.

There has to be something weird going on? Case...

Gus is in FL, right? I'll keep my ears open.

Glad it's working, and you are welcome.

I believe some other products fire the trigger for each row, so you have to know your RDBMS. This is a common issue that...

I'll chime in with another note for Dell. I have a 17" Dimension laptop, circa 2002, that still runs fine. The battery is shot and the internal radio is whacked,...

Thanks for the edit. Actual exam questions are not allowed. However if there is a concept that you did not understand, you can ask about the subject, just not the...

The US is very litigious, but I don't think that extends to employment very often, sexual harassment being the most prominent, maybe race/age discrimination.

However HR departments are very conservative here...

I would agree with the advice for 2008. I'm not sure it makes sense to go to 2005 as support is already waning on that product (it's 2010, 5 years...

Jeff is correct. Triggers only respond to actions, not inactions.

A job with a check is what I'd do.

A couple things:

- Windows auth or sql auth?

- Are you sure the Excel connection is hitting the right VM? Could there be multiple copies out there? Or a naming...

It's not emergency mode. There's no such thing. There is an emergency status for a database, but you are confusing the issue if you call this emergency mode. It's single...

Query Analyzer is a SQL 2000 product, not a SQL 2008 one. Are you using SQL 2008?

If you run SSMS you have different panes. Some of these panes make separate...

I would use mirroring. It's easier to maintain for sure. A little more complex to understand, but not what I'd call really complex. It will keep things in sync for...

I am sure it will evolve, but I have no information as to when it will get included in the product.