Viewing 12 posts - 1 through 12 (of 12 total)
I use dbWarden:
December 21, 2017 at 2:21 am
I think the key to this is insurance. If you buy agricultural products, it is possible to insure the quality and there are specialist companies that do this (SGS, Cotecna)....
May 15, 2014 at 3:53 am
What I've noticed is that management have lost respect for their work force. When the time comes to downsize someone they become a post or a role and not a...
December 15, 2009 at 7:41 am
I think the problem IT departments have is lack of control. If these little applications are developed beyond their control, IT are left holding the can when the developer leaves....
October 1, 2009 at 5:51 am
Just out of interest, how would you use a SQL AGENT job?
January 14, 2005 at 1:28 am
Hmm, I was saving that as a last resort in case someone could come up with and explanation and/or solution. Its looking increasingly likely that the table will have to...
November 19, 2004 at 8:38 am
This won't work here, I've been trying to do this for weeks. EM has been restarted numerous times and the server re-booted.
November 19, 2004 at 8:01 am
The triggers are :
If I try to drop triggers that do not exist I get this:
Server: Msg 3701, Level 11, State...
November 18, 2004 at 7:11 am
I usually do this in an ADP Access database, but yes, when that failed I tried it in Enterprise manager - hence the saga of trying to drop it via...
November 18, 2004 at 5:54 am
I ran it from a batchfile I keep for these purposes. It runs nightly. The command line I used was:
osql -E -S Orinoco -i DropTriggersOnNewTblProperty.sql > 17112004_2.txt
there was no error...
November 18, 2004 at 5:43 am
this is the script that I was trying to run last night:
drop Trigger dbo.NewTblProperty_TriggerUpdateSurveyor
drop Trigger dbo.NewTblProperty_UpdateSurveyor
November 18, 2004 at 5:28 am
I think its Dr Codd - thanks be to Codd! But otherwise, you made some good points
June 2, 2003 at 1:19 am