Viewing 11 posts - 1 through 11 (of 11 total)
I agree that there are few times when a trigger is better than a view or more pragmatic programming. However, in this case it is neccessary. I am...
January 23, 2012 at 9:27 am
It's a simple enough trigger. I am not changing any data, rather just moving data. In essence this is what I am doing.
Similair to a history...
January 20, 2012 at 2:59 pm
Thank you for the verification. No matter how many years you do this you always come across something new.
😎
January 18, 2012 at 8:58 am
That is what I thought. I understand that the trigger would fire on any update to the specified table, but I just wasn't sure if you could extend the...
January 17, 2012 at 3:37 pm
Found a good example after some more reading and a few examples.
CONVERT(varchar, DATEDIFF(n, @start, @end)/60) + ':'
+ RIGHT('0' + CONVERT(varchar, (DATEDIFF(n, @start, @end)%60)), 2)
To round to the nearest minute...
December 30, 2011 at 4:44 pm
As to a soultion to your query. What I would do, since you seem to be worried about the expense and attention given to other employees at differing times,...
December 27, 2011 at 9:41 am
Thanks for the response and code example. This gives me a better idea on how to use it. I will have to give it a try.
SSCRAZY:...
November 9, 2010 at 10:17 am
You'll have to excuse me as I am not well versed in VB. Again I am trying to locate a pdf file that was created on x day and...
November 8, 2010 at 11:15 am
[p]Thanks for the 10 per instance. I looked all over for this. It appears that I should really look at a combination of mirror and log shipping. ...
September 13, 2010 at 4:15 pm
I am unfamiliar with the term bouncing. What do you mean by this.
I am mirroring 14 db's ranging in size from 40mb to 200GB.
After...
September 13, 2010 at 3:49 pm
I found a solution that I will have to investigate once I can get the mirror DB up and can edit its growth parameters. It talks about the log...
September 13, 2010 at 11:52 am
Viewing 11 posts - 1 through 11 (of 11 total)