Forum Replies Created

Viewing 15 posts - 1 through 15 (of 28 total)

  • RE: Function in join

    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...

  • RE: Function in join

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

    Thanks for the suggestions.

  • RE: Finding the Greatest

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

     

  • RE: Finding the Greatest

    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

       ...

  • RE: Undo Last Query

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

    -c

  • RE: Help tracking down user null

    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...

  • RE: Sporadic performance problem

    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.

  • RE: How to audit users on SQL

    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...

  • RE: REBUILDM.EXE failed with error -1

    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...

  • RE: dbo login account

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

    -c

  • RE: dbo login account

    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....

  • RE: dbo login account

    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...

  • RE: dbo login account

    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...

  • RE: No Daily Update

    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...

  • RE: restore a able using tranaction log

    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...

Viewing 15 posts - 1 through 15 (of 28 total)