Viewing 15 posts - 1 through 15 (of 28 total)
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...
October 31, 2007 at 11:26 am
That makes sense to me. Good idea. I'll try putting this in an indexed view.
Thanks for the suggestions.
October 31, 2007 at 11:10 am
Perfect. That works great. Thank you very much with your help on this query.
April 3, 2007 at 8:55 am
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
...
April 2, 2007 at 2:22 pm
A program like log explorer could get one out of that situation. But that involves $$$. David's suggestions is a good one.
-c
February 20, 2006 at 7:41 am
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...
February 7, 2006 at 7:39 am
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.
February 6, 2006 at 2:42 pm
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...
February 6, 2006 at 10:00 am
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...
February 2, 2006 at 3:21 pm
Never mind...it does work. I just used sp_changedbowner and all is happy. Thanks for your help.
-c
January 31, 2006 at 12:47 pm
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....
January 31, 2006 at 7:15 am
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...
January 27, 2006 at 1:20 pm
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...
January 27, 2006 at 12:09 pm
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...
December 16, 2005 at 7:31 am
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...
November 23, 2005 at 1:39 pm
Viewing 15 posts - 1 through 15 (of 28 total)