What i understand is that u want to insert a changed valur for a perticular column.
If that is so, try to use "Insead Of Insert".
declare @info
selsct @info = info from inserted
if @info = 8
Begin
-----rewrite the insert statement with the value of info change
end
else
begin
---- rewrite the insert statement with the original data....
Shaily
Last Activity: Dec 17 '06, 01:23 PM
Joined: Nov 1 '06
Location:
-
Hi Sona,
I too have faced the same problem. In my case there were 2 causes.
1)The size of log file was restricted to 2 MB and the log had already grown to this size. By taking the backup of the Log the size could be decreased. If the disk is out of space it would again give an error during backup.
If you are not out of disk space try either of the two
i) Take a backup of the log...Leave a comment:
-
Hi Sona,
I too have faced the same problem. In my case there were 2 causes.
1)The size of log file was restricted to 2 MB and the log had already grown to this size. By taking the backup of the Log the size could be decreased. If the disk is out of space it would again give an error during backup....Leave a comment:
No activity results to display
Leave a comment: