Any relations defined in a SQL Diagram won't "transfer" to a relations diagram in Access.  It just doesn't from what I've seen.  Meaning - they're still enforced on the SQL...

Steve -

Did we move to a different timezone or something?  Time stamps on posts look to have jumped 7 hours  into the future (from Mountain to GMT perhaps?)

Otherwise -...

That's roughly my understanding (certainly how we used it).  Active/Active is essentially two Active/Passive instances "shared" between two nodes.  As to whether it should deal with single applications or multiple...

At my last job - we had a special recognition for the "most passionate" tech on the team.  Once a month, we put in submissions for the "Mr./Mrs. Cranky poopy...

...sheesh... and I thought EVERYONE had 20K just laying around to buy a 4-processor license of SQL 2005 at their discretion:P... (Trust me I understand)

It was more along the lines of...

must be in JDBC, because query analyzer doesn't have any problem with it.

right-click on the database from within SS Management Studio, pick Properties, then files.  You should then see a box in the top right with the DB owner account (in your...

From within the DTS package editor: Package, Properties.  Second tab is Global Variable.

You'll then want to insert towards the beginning of your workflow (or wherever appropriate) a Dynamics property task,...

Oh I know the feeling Greg - I'm mostly too dumb to duck and keep quiet  I prefer to mix it up a little...

The purpose of SQL injection attacks is to breach security.  Giving someone an open door into getting to data they shouldn't have is usually a problem. it'd be fairly easy to...

Did you happen to make the primary key the clustered index of your table?  Also - did you do this from Enterprise manager or from Query Analyzer?

Enterprise manager seems to...

well - if you were to get this anywhere near a SQL 2005 DB (instead of ole 2000), you could read that very interesting article in BOL about "creating custom...

Chris - I don't think you want to use a function for this, at least not to return a scalar value.  If you have 7 columns per record, and 1000...

Well since we're working in theoreticals - try this one on for size.  How you USE it is a different story.

Asset table: <assetID>, <assetname>, <whatever else>

component type: <comptypeID>, <comptype>,<whatever else>

Asset...

Well - you'd have to introduce something new to make that work.  The purpose of PIVOT or cross-tabulation (or the older syntax in 2000) is to produce a single value...