Viewing 15 posts - 16 through 30 (of 33 total)
Thank you very much, but as I wrote in my initial post, I already discarded this option, because the count of the detail is not limited to 2. In most...
February 6, 2009 at 6:57 am
I need to retrieve the guys that have both ('CIMP' and 'INS' in my example).
February 6, 2009 at 6:44 am
Ok, I should have checked all the tabs I opened before posting here. Found a solution:
I ran
GRANT ALTER ON SCHEMA::dbo TO RoleName
and it worked.
September 11, 2008 at 6:16 am
I have a similar problem.
I try to create a view from our database application, which fails with the error mentioned in the first posting (the user has the CREATE VIEW-permission).
Funny...
September 11, 2008 at 6:12 am
there was an index service running on the sql-server which was used, instead of the one on our file server
:Whistling:
July 9, 2008 at 7:52 am
I think I'll go for the one log, one full backup file version.
thank you very much!
:w00t:
April 3, 2008 at 6:07 am
just to make sure I understood that right:
I schedule the following steps
-Full Backup at lets say 00:00
-Log Backup with INIT at 00:30
-Log Backup with NOINIT every hour, starting from 01:00...
April 3, 2008 at 5:28 am
Maybe you have set the WITH NOINIT option ... this appends every backup to the file, which means your backup file grows by the size of your database, every time...
February 8, 2008 at 5:42 am
Thanks for ur advices. I think I'll go for the "UNKNOWN" - value thing.
November 16, 2007 at 4:27 am
Hello Ken,
I tested the query you posted and it works just the way I wanted it to. Great, thanks a lot! :w00t:
For future issues:
I dont completely get how you did...
October 9, 2007 at 4:26 am
mengus (10/4/2007)
Please keep in mind to help your fellow SQLServerCentral members by posting table structure and sample data, so that we can be at our best in helping you.
Please try...
October 4, 2007 at 6:59 am
I greatly appreciate your answer, thanks a lot.
to specify my concern:
Put seperate indexes on seperate columns when queries use different columns. an index on 2 columns ColA, ColB cannot...
July 23, 2007 at 3:51 am
Yeah, the problem is - as i figured out - that I'm using the AfterUpdate-event of the field, which occurs a bit to early.
I should use the after update...
June 4, 2007 at 11:21 am
Ah, very helpful again. Thanks a lot! A lot things are done with such logical operations instead of functions like CASE or IF as I see...
April 17, 2007 at 4:32 am
Ok, thats good to know. Thank you!
March 22, 2007 at 9:02 am
Viewing 15 posts - 16 through 30 (of 33 total)