Thanks for trying.....I am hoping it was "one of those MS anomalies" and it never happens again!

I spoke to our admins and they had not done anything. We found there was service pack 3 that included fixes for the areas that we felt could have...

I have to agree with the idea of a 5 to 6 year period between releases. I currently work in a mid-sized company developing specialized software for a group...

Cimode

I take great exception to the tone you have used in your responses.  This is a forum for people to share ideas and experiences and you calling us ignorant because...

In the afternoon a Cappuccino made on my Tassimo and perhaps a bit of chocolate.  Nothing like some caffine to get the brain moving......

Hi Eric,

If I am reading your question correctly I believe your initial thought of using that cross reference table to join a model to a "user" entity (By user entity I...

I found this article interesting and so I thought I would give it a go.  After working through some connnection and data population issues I have found something I can't seem...

David,

In refrence to your question about Global tables and their scope.  A global table with be deleted when all connections refrencing it have been terminated.  So if you create a...

This may have something to do with the way your linked server is configured (there are 4 security options for linked servers) since the security for an execution from Query analyzer and an...

Paul,

Just an FYI....I use the Provider for my linked servers and give the link a generic name.  I do this so when I do cross server joins I do not...

Keep in mind that if you run this once a day you can't be sure to record all changes since if your data changes more than once in a day...

Here is a different take than above.  It did use charindex as suggested above and len to find the starting point length of the part for each of the 4 parts.  I...