That would be a good option, however I'm a little hesitant to modify the table structure. This is a third party application and they will every now and then...

That makes sense to me. Good idea. I'll try putting this in an indexed view.

Thanks for the suggestions.

Perfect.  That works great.  Thank you very much with your help on this query.

Thanks Julie.  I did change it a little:

SELECT

OuterQuery.ID

 , OuterQuery.School

 , ISNULL( OuterQuery.EndYear, '' )

 FROM #INSTITUTIONS_YEARS OuterQuery

  INNER JOIN

   ( SELECT ID, MAX( ISNULL( EndYear, '' )) as EndYear

   ...

A program like log explorer could get one out of that situation. But that involves $$$. David's suggestions is a good one.

-c

Thanks for all the wonderful suggestions. I ended up taking a more trial and error approach. I did discover the username that was trying to login was an...

You can use performance monitor to analyize the load on the server. See if the server is running slugish before and during the query is execution.

A while back Chad wrote an column using DumbSQLSec. I've played around with it a little bit and might work for what you need. Here is the column...

I've heard of error messages occuring when restoring the master db from CD. It has something to do with the cd being read only media. So I make...

Never mind...it does work. I just used sp_changedbowner and all is happy. Thanks for your help.

-c

Thanks for your help. Sorry this post is a little late but I've been away for a couple days.

So I tried your method and had trouble from the start....

This is what I came up with:

--Allow modifications of system tables

exec sp_configure 'allow updates',1

go

reconfigure with override

--Change the old db user to the new one

update sysusers set sid =0x01050000000000051500000027497463930396536E34DF1251440000 where uid...

That's always been my impression. But however they setup the software there is a user named dbo with a login of domain\support. Now...it does not show up like...

Jaysen, did you get one today? I still haven't. The funny thing is that I receive the notifications that people have responded to posts I've made. Just...

You could probably use a log viewer program like Lumgents Log Explorer or ApexSQL Log. I believe they will work without a full backup. Lumgents reads the log...