I use GUIDs as my PK for pretty much every table that has "meaningful" data, relegating any natural keys to a secondary role. Our reasoning behind GUIDs versus identity...

I think you're right on by looking at the airline industry for huge reductions in oil dependency. Interestingly, the US Air Force has been exploring alternate fuels such as...

I'm with MattieNH in that a table where you know you'll only have one row (such as a table that holds system configuration settings, etc) wouldn't need a PK. ...

Sweet! Thanks, I think that will do the trick.

I need to generate a report listing what ID ranges have been used.

Jeff... thanks for the reply. That code works like a champ, but unfortunately I need the IDs that are present, not the ones missing. My ID range will...

I work with an organization in Arlington, VA who is on the 2nd floor of one of the high-rises in Crystal City. A well-known "prime" steakhouse is located on...

I currently have 2579 XML documents stored in the DB (about 44meg) and we have 579 users. Yeah, our system is pretty small in comparison to what you were...

I'm currently using "classic ASP" for this system as it's web-based, so I extract the XML using an ADO recordset, load an MSXML IXMLDOMDocument object using the LoadXML method, then...

I'm the developer of a system that creates security documentation (DoD-mandated). These documents are around 40+ pages and the system has a "wizard" for leading the user section-by-section to...

Don't forget there is a table called "inserted" that contains newly added/updated records which you can access via a FOR INSERT or FOR UPDATE trigger.

You can also use the "Generate SQL Script" option thru EM by right-clicking on a database and selecting this option from "All Tasks". You'll be able to select which...

I think I like Ian's last suggestion. We'll hire a contractor and tell them it's for a "short term" position. 🙂 Thanks everyone for the suggestions. I'll...

Gift Peddie... the problem with that approach is that PDF requires a security password be set. You also have to confirm the password, so you can't just hit a...

Here's some VB6 code. This is cut-and-pasted, slightly modified, from something I've done, so it might not be 100% right...

SQL TABLE

---------

FileID ...